【记录一下】获取根据单据类型关联的业务类型

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

【记录一下】获取根据单据类型关联的业务类型

![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...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息