U9枚举、公共扩展段查询

1、枚举值查询

select h.UID,g.EValue ,g.Code,i.Name  from   UBF_Sys_ExtEnumValue as g
inner join UBF_Sys_ExtEnumType as h on g.ExtEnumType =h.ID
inner join  UBF_Sys_ExtEnumValue_Trl as i on g.ID =i.ID
where h.Code ='DocType'
--DocType 为枚举值类型 如：UFIDA.U9.InvDoc.TransferOut.SrcDocTypeForTransOutEnum

2、公共扩展段查询

select Base_DefineValue.Code,Name
from Base_DefineValue_Trl
inner join Base_DefineValue on Base_DefineValue.ID=Base_DefineValue_Trl.ID
inner join Base_ValueSetDef on Base_ValueSetDef.ID=ValueSetDef
where Base_ValueSetDef.Code='XXX'   ---XXX是扩展字段值集的编码