ZDY023 是自定义值集的值集编码
select B.Name from UFIDA::U9::Base::FlexField::ValueSet::DefineValue B where B.ValueSetDef.Code='ZDY023' and B.Code in (
...查询扩展字段Code的语句...
)
例如:帝欧系统-成品入库单-扩展字段 2(入库部门)
select B.Name from UFIDA::U9::Base::FlexField::ValueSet::DefineValue B where B.ValueSetDef.Code='ZDY023' and B.Code in (
select UFIDA::U9::Complete::RCVRpt::RcvRptDocLine.RcvRptDoc.DescFlexField.PrivateDescSeg2 as 实体扩展字段_私有段2 from UFIDA::U9::Complete::RCVRpt::RcvRptDocLine
where UFIDA::U9::Complete::RCVRpt::RcvRptDocLine.RcvRptDoc.DocNo='Co-2202094285')
评论 (0)