云星空K3Cloud常用SQL总结
--物料名称
select m.fmaterialid,m.fmasterid, fname,m.fnumber from t_bd_material m join
t_bd_material_l l on
l.fmaterialid=m.fmaterialid
where 1=1
--and m.fmaterialid=147002
and 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.FORGID
select l.FNAME,* from T_ORG_ORGANIZATIONS o
join T_ORG_ORGANIZATIONS_L l on l.FORGID=o.FORGID
--部门
select b.FNAME,* from T_BD_DEPARTMENT a join T_BD_DEPARTMENT_L b on
a.FDEPTID=b.FDEPTID
--参数
select * from t_bas_sysparameter
--用户
select * from T_SEC_USER
云星空K3Cloud常用SQL总结
--物料名称select m.fmaterialid,m.fmasterid, fname,m.fnumber from t_bd_material m joint_bd_material_l l onl.fmaterialid=m.f...
点击下载文档
本文2024-09-16 17:15:56发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14591.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章