CLOUD 5.0 应收单跟踪表报错
金蝶云社区-云社区用户2NSC1234
云社区用户2NSC1234
0人赞赏了该文章 702次浏览 未经作者许可,禁止转载编辑于2015年01月15日 10:25:19


[tr][td]CLOUD 5.0 应收单跟踪表报错:
错误代码:

DELETE FROM #TM_AR_TraceReport WHERE EXISTS (SELECT 1 FROM T_AR_REFUNDBILLSRCENTRY_LK ARUBSK INNER JOIN T_AR_REFUNDBILLSRCENTRY ARUBSY ON (ARUBSY.FENTRYID = ARUBSK.FENTRYID AND (ARUBSY.FREALREFUNDAMOUNT <> 0)) INNER JOIN T_AR_REFUNDBILL ARUBS ON ARUBS.FID = ARUBSY.FID INNER JOIN V_FIN_CONTACTTYPE_L vl ON (vl.FITEMID = ARUBS.FRECTUNIT AND vl.FLOCALEID = 2052) INNER JOIN T_ORG_ORGANIZATIONS_L orgl ON ((orgl.FORGID = ARUBS.FPAYORGID AND orgl.FLOCALEID = 2052) AND (ARUBS.FDOCUMENTSTATUS <> 'Z')) INNER JOIN T_CN_PAYAPPLYENTRY_LK T_CN_PAYAPPLYLK ON (T_CN_PAYAPPLYLK.FENTRYID = ARUBSK.FSID AND ARUBSK.FSTABLENAME = 'T_CN_PAYAPPLYENTRY') INNER JOIN T_CN_PAYAPPLYENTRY_LK APPLY78LK ON (APPLY78LK.FENTRYID = T_CN_PAYAPPLYLK.FSID AND APPLY78LK.FSTABLENAME = 'T_CN_PAYAPPLYENTRY') INNER JOIN T_CN_PAYAPPLYENTRY_LK ARRE80LK ON (ARRE80LK.FENTRYID = APPLY78LK.FSID AND ARRE80LK.FSTABLENAME = 't_Cust_Entry100059') LEFT OUTER JOIN T_CN_PAYAPPLY ARRE80 ON ARRE80.FID = ARRE80LK.FSBILLID INNER JOIN t_Cust_Entry1