合并范围-合并单元对应查询SQL
```language
SELECT T1.FNUMBER "合并范围编码",T1.FNAME_L2 "合并范围名称",T2.FNUMBER "组织编码",T2.FNAME_L2 "组织名称",T0.FLONGNUMBER "组织长编码",T0.FDISPLAYNAME_L2 "组织长名称"
FROM T_ORG_STRUCTURE T0
LEFT JOIN T_ORG_Tree T1 ON T0.FTREEID = T1.FID
INNER JOIN T_ORG_BASEUNIT T2 ON T0.FUNITID = T2.FID
WHERE T0.FTREEID = (SELECT TOP 1 FID FROM T_ORG_Tree where FNUMBER ='01' order by FSTARTDATE DESC)
ORDER BY T0.FLongNumber ASC
```
合并范围-合并单元对应查询SQL
```languageSELECT T1.FNUMBER "合并范围编码",T1.FNAME_L2 "合并范围名称",T2.FNUMBER "组织编码",T2.FNAME_L2 "组织名称",T0.FLONGN...
点击下载文档
本文2024-09-16 21:56:46发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-44932.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章