[SQL]单据上的物料查询相关信息

星空物料相关信息sql

--物料相关信息 select a.fnumber 物料, a1.fname 物料名, case a.fdocumentstatus when 'Z' then …

单据类型查询SQL

SELECT a.fbilltypeid, a.fnumber, b.fname FROM T_BAS_BILLTYPE a LEFT JOIN T_BAS_B …

SQL查询枚举值，单据类型

SELECT a.FENUMID AS 枚举内码,b.FCAPTION AS 枚举名称,a.FVALUE AS 枚举值, FROM T_META_FORMENU …