--物料名称
select m.fmaterialid,m.fmasterid, fname,m.fnumber from t_bd_material m join t_bd_material_l l on l.fmaterialid=m.fmaterialidwhere 1=1--and m.fmaterialid=147002and m.fnumber='XACPWM0067'--and l.fname like '%扯面%'order by m.fmaterialid desc
--组织
select V_SCM_OWNERORG_L.FNAME,* from V_SCM_OWNERORG left join V_SCM_OWNERORG_L on V_SCM_OWNERORG.FORGID=V_SCM_OWNERORG_L.FORGIDselect l.FNAME,* from T_ORG_ORGANIZATIONS ojoin T_ORG_ORGANIZATIONS_L l on l.FORGID=o.FORGID
--元数据
select * from t_meta_objecttype_l ml,t_meta_objecttype m where fname like '%工序汇报%' and ml.fid=m.fid--部门select b.FNAME,* from T_BD_DEPARTMENT a join T_BD_DEPARTMENT_L b on a.FDEPTID=b.FDEPTID
--单据转换
select * from T_META_CONVERTRULE where fid='PlanOrder_PPBom'
--通过元数据唯一id查询菜单
select * from T_META_CONSOLEDETAIL where FOBJECTID like '%stk_%'
--反写规则select rl.FNAME, * from T_BF_WRITEBACKRULE rleft join T_BF_WRITEBACKRULE_L rl on rl.FID=r.FID and rl.FLOCALEID=2052left join T_BF_WRITEBACKRULECUST rc on r.FID=rc.FID
