一，相关的人员关联表

表名 字段名 表用途说明

CBO_Account_Trl CombineName 与固定资产不关联，不是固定资产调用的人员表（财务表-账目信息）

CBO_Operators_Trl Name 固定资产 - 操作员维护表

FA_AssetCard OwnerName 固定资产卡片（表头）-数据表

FA_AssetCard_Trl AssetDescription 固定资产描述

[dbo].[FA_AssetTagSum] 固定资产标签名称与关联表

[dbo].[FA_AssetTag] 固定资产标签信息详细表

FA_AssetTagUsageInformation UsagePrincipalName 固定资产标签使用者信息

GL_Entry OpposingAccountNames 财务表 - 入账信息

GL_SubsidiaryLedger_Trl Abstracts

InvDoc_MiscShipL_Trl Memo

UBF_Log_OperateLog Description

一，相关的部门关联表

表名 字段名 表用户说明

AAI_AccountTemplate AccountSegNames

AAI_AccountTemplate AccountSegValue5Name

AAI_AccountTemplate FactorNames

AAI_AccountTemplate FactorValue1Name

AAI_AccountTemplate FactorValue3Name

AP_APBillLine_Trl Memo

AP_APPostedDetail_Trl Digest

CBO_Account_Trl CombineName

CBO_Account_Trl DisplayName

CBO_Account_Trl FirstLastName

CBO_Account_Trl FullLevelName

CBO_Account_Trl LeafName

CBO_Account_Trl Name

CBO_Department_Trl Name 部门表

CBO_Department_Trl TreeDisplayName

CBO_ReCilSetFALine AuditDeptName

CBO_ReCilSetFALine OwnerDeptName

GL_Entry OpposingAccountNames

GL_Entry_Trl AccountCombineName

GL_Entry_Trl AccountDisplayName

GL_Entry_Trl AccountFirstLastName

GL_Entry_Trl AccountFullLevelName

GL_Entry_Trl AccountLeafName

InvDoc_MiscShipL DescFlexSegments_PrivateDescSeg2

InvDoc_MiscShipL_Trl DescFlexSegments_CombineName

InvDoc_MiscShipL_Trl Memo

PM_PMStatistics DescFlexField_PrivateDescSeg2

PM_PMStatistics DescFlexField_PrivateDescSeg4

PM_PMStatistics_Trl DescFlexField_CombineName

PM_POLine DescFlexSegments_PrivateDescSeg1

PM_POLine_Trl DescFlexSegments_CombineName

PM_POMemo_Trl Description

PM_RcvLine DescFlexSegments_PrivateDescSeg2

PM_RcvLine DescFlexSegments_PrivateDescSeg4

PM_RcvLine_Trl DescFlexSegments_CombineName

PM_RcvLine_Trl Memo

PR_PR_Trl Memo

PR_PRLine_Trl Memo

UBF_Log_OperateLog Description

UBF_Sys_ExtEnumValue Code

UBF_Sys_ExtEnumValue_Trl Name

表之间的关联关系

固定资产的受益人（操作员，使用人）表 (CBO_Operators_Trl) ,设置ID跟姓名即可，ID对应一个部门