[toc]

一、收款单关系图

image.png

@startuml
T_AR_RECEIVEBILL : 收款单表
T_AR_RECEIVEBILL : FID 唯一编号
T_AR_RECEIVEBILL : FDOCUMENTSTATUS = 'C' 状态已审核
T_AR_RECEIVEBILL : FDATE 业务时间
T_AR_RECEIVEBILL : F_SYB_ASSISTANT 事业部编号
T_AR_RECEIVEBILL : F_kd_Text_SYB 事业部（核销）
 
 
T_AR_RECEIVEBILL --> T_BD_RATE:T_AR_RECEIVEBILL.FCURRENCYID = T_BD_RATE.FCYFORID
 
T_BD_RATE:汇率表（用于换算成人民币）
T_BD_RATE:FCYFORID  币种编码
T_BD_RATE:FBEGDATE 汇率生效时间，一个月更新一次
T_BD_RATE:FEXCHANGERATE 直接汇率
T_BD_RATE:FRATETYPEID = '8355919' 汇率类型编码，取美元兑换人民币列表
 
 
T_AR_RECEIVEBILL --> T_AR_RECEIVEBILLENTRY : T_AR_RECEIVEBILL.FID = T_AR_RECEIVEBILLENTRY.FID
 
T_AR_RECEIVEBILLENTRY: 收款明细表
T_AR_RECEIVEBILLENTRY: FID 唯一编号
T_AR_RECEIVEBILLENTRY: FLOCALEID = '2052' 翻译语言：中文
T_AR_RECEIVEBILLENTRY: FPURPOSEID 收付款用途编号
T_AR_RECEIVEBILLENTRY: FREALRECAMOUNTFOR 实收金额
 
T_AR_RECEIVEBILLENTRY --> T_CN_RECPAYPURPOSE_L :T_AR_RECEIVEBILLENTRY.FPURPOSEID = T_CN_RECPAYPURPOSE_L.FID
 
T_CN_RECPAYPURPOSE_L:收付款用途表（目前只用于收款）
T_CN_RECPAYPURPOSE_L:FID 唯一编号
T_CN_RECPAYPURPOSE_L:FNAME not Like '%调拨%'   收付款用途不等于 调拨单
T_CN_RECPAYPURPOSE_L:FLOCALEID = '2052' 翻译语言：中文
 
 
T_BAS_ASSISTANTDATAENTRY_L --> T_BAS_ASSISTANTDATAENTRY:T_BAS_ASSISTANTDATAENTRY.FMASTERID = T_BAS_ASSISTANTDATAENTRY_L.FENTRYID
T_BAS_ASSISTANTDATAENTRY:辅助资料表
T_BAS_ASSISTANTDATAENTRY:事业部的FID = '59832ad438268e'
 
T_AR_RECEIVEBILL-->T_BAS_ASSISTANTDATAENTRY_L:T_AR_RECEIVEBILL.F_kd_Text_SYB = T_BAS_ASSISTANTDATAENTRY.FDATAVALUE
T_BAS_ASSISTANTDATAENTRY_L:辅助资料明细表
T_BAS_ASSISTANTDATAENTRY_L:辅助资料（事业部）文案 FDATAVALUE
@enduml

付款单关系图

image.png

@startuml
T_AP_PAYBILL : 付款单表
T_AP_PAYBILL : FID 唯一编号
T_AP_PAYBILL : FDOCUMENTSTATUS = 'C' 状态已审核
T_AP_PAYBILL : FDATE 业务时间
T_AP_PAYBILL : F_SYB_ASSISTANT 事业部编号
T_AP_PAYBILL : F_kd_Text_SYB 事业部（核销）

T_AP_PAYBILL --> T_BD_RATE:T_AP_PAYBILL.FCURRENCYID = T_BD_RATE.FCYFORID

T_BD_RATE:汇率表（用于换算成人民币）
T_BD_RATE:FCYFORID  币种编码
T_BD_RATE:FBEGDATE 汇率生效时间，一个月更新一次 
T_BD_RATE:FEXCHANGERATE 直接汇率
T_BD_RATE:FRATETYPEID = '8355919' 汇率类型编码，取美元兑换人民币列表


T_AP_PAYBILL --> T_AP_PAYBILLENTRY : T_AP_PAYBILL.FID = T_AP_PAYBILLENTRY.FID

T_AP_PAYBILLENTRY: 付款明细表
T_AP_PAYBILLENTRY: FID 唯一编号
T_AP_PAYBILLENTRY: FLOCALEID = '2052' 翻译语言：中文
T_AP_PAYBILLENTRY: FPURPOSEID 收付款用途编号
T_AP_PAYBILLENTRY: FREALRECAMOUNTFOR 实收金额
T_AP_PAYBILLENTRY: FCOSTID 费用项目ID

T_BAS_ASSISTANTDATAENTRY_L --> T_BAS_ASSISTANTDATAENTRY:T_BAS_ASSISTANTDATAENTRY.FMASTERID = T_BAS_ASSISTANTDATAENTRY_L.FENTRYID
T_BAS_ASSISTANTDATAENTRY:辅助资料表
T_BAS_ASSISTANTDATAENTRY:事业部的FID = '59832ad438268e'

T_AP_PAYBILL-->T_BAS_ASSISTANTDATAENTRY_L:T_AP_PAYBILL.F_kd_Text_SYB = T_BAS_ASSISTANTDATAENTRY.FDATAVALUE
T_BAS_ASSISTANTDATAENTRY_L:辅助资料明细表
T_BAS_ASSISTANTDATAENTRY_L:辅助资料（事业部）文案 FDATAVALUE

T_AP_PAYBILLENTRY-->T_BD_EXPENSE_L:T_AP_PAYBILLENTRY.FCOSTID = T_BD_EXPENSE_L.FEXPID
T_BD_EXPENSE_L:费用项目表
T_BD_EXPENSE_L:FEXPID 唯一编号
T_BD_EXPENSE_L:FDESCRIPTION 备注：二级收支类别：业务收入等
T_BD_EXPENSE_L:FNAME  费用项目明细
T_BD_EXPENSE_L:FLOCALEID = '2052' 翻译语言：中文

T_BD_EXPENSE_L-->T_BD_EXPENSE:_BD_EXPENSE_L.FEXPID=T_BD_EXPENSE.FEXPID
T_BD_EXPENSE:费用分组-费用项目关联表
T_BD_EXPENSE:FEXPID 唯一编号
T_BD_EXPENSE:FGROUP 费用分组编号
T_BD_EXPENSE-->T_BD_EXPENSE_GROUP_L:T_BD_EXPENSE.FGROUP = T_BD_EXPENSE_GROUP_L.FID
T_BD_EXPENSE_GROUP_L: 费用分组
T_BD_EXPENSE_GROUP_L: FID 唯一编号

@enduml