【记录一下】获取根据单据类型关联的业务类型
![1684828327481.webp](/download/0100eebdf994ca44489486ae70c974ec022c.webp)
![image.webp](/download/01000dc3481202ce43cc9e2176f2d1540d01.webp)
``` sql
SELECT
T1.FNAME,
T2.FNumber,
V.FVALUE,
V.FCAPTION
FROM T_BAS_BILLTYPE_L t1
INNER JOIN T_BAS_BILLTYPE t2 on t2.FBILLTYPEID=t1.FBILLTYPEID
INNER JOIN (
SELECT C.FVALUE,D.FCAPTION
FROM T_meta_formenum a
INNER JOIN T_META_FORMENUM_L b on a.FID=b.FID and b.FLOCALEID=2052
INNER JOIN T_META_FORMENUMITEM C ON C.FID=a.FID
INNER JOIN T_META_FORMENUMITEM_L D on C.FENUMID=D.FENUMID and D.FLOCALEID=2052
WHERE b.FNAME='收付款用途的业务类型'
) V ON V.FVALUE=FPARASETTINGXML.value('(/BILLTYPEPARAMODEL/BUSINESSTYPE)[1]','NVARCHAR(max)')
WHERE
t1.FLOCALEID=2052
AND t2.FBILLFORMID='AP_PAYBILL'
AND FDOCUMENTSTATUS='C'
AND FPARASETTINGXML.exist('/BILLTYPEPARAMODEL/BUSINESSTYPE') = 1
```
![image.webp](/download/010038168ee3f29740e19c54048a5a9a62f2.webp)
【记录一下】获取根据单据类型关联的业务类型
![1684828327481.webp](/download/0100eebdf994ca44489486ae70c974ec022c.webp)![image.webp](/download/01000dc3481202ce43cc9e2176f2d154...
点击下载文档
本文2024-09-16 17:14:33发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14445.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章