/** * 下拉列表视图 --ERP 基础 * add by linzhaoh at 2023.05 **/ alter View formenumView as SELECT a.FID,bl.FENUMID,b.FVALUE as enumItem,b.FINVALID as seq,bl.FCAPTION as enumName,bl.FLOCALEID FROM t_meta_formenum a left join t_meta_formenumitem b on a.fid = b.FID left join T_META_FORMENUMITEM_L bl on b.FENUMID = bl.FENUMID ------------------------------------- /** * 单选辅助资料视图 **/ ALTER VIEW [dbo].[V_BAS_ASSISTANTDATAENTRY_L] AS SELECT db.FPKID, db.FENTRYID fid, db.FLOCALEID, FDATAVALUE fname FROM T_BAS_ASSISTANTDATAENTRY_L db GO -------------------------------------------- /*** * * 单据类型列表 * add by linzhaoh at 2023.05 * ***/ create view billTypeView as select a.FBILLTYPEID,a.FNUMBER,a.FBILLFORMID,b.FLOCALEID,b.FNAME,b.FDESCRIPTION from T_BAS_BILLTYPE a left join T_BAS_BILLTYPE_L b on a.FBILLTYPEID = b.FBILLTYPEID -------------------------------------------