SQL查询枚举值，单据类型

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

SQL查询枚举值，单据类型

``` SELECT a.FENUMID AS 枚举内码,b.FCAPTION AS 枚举名称,a.FVALUE AS 枚举值,* FROM T_META_FORMENUMITEM a LEFT JOIN T_META_FORMENUMITEM_L b ON a.FENUMID=b.FENUMID AND b.FLOCALEID=2052 WHERE a.FID='0113bd8e-03b1-4c47-8fb4-9ed5b9074680' ORDER BY a.FSEQ select t1.FBILLTYPEID "单据类型ID",t1.FNUMBER "单据类型编码",t2.FNAME "单据类型名称" from T_BAS_BILLTYPE t1 left join T_BAS_BILLTYPE_L t2 on t1.FBILLTYPEID=t2.FBILLTYPEID and t2.FLOCALEID=2052 where t1.FBILLFORMID='PRD_MORPT'