SELECT 客户号,
销售人员,
预约单号,
产品名称,
"预约金额(元)",
进账金额,
最后进账日期,
进账状态
FROM (SELECT 客户号,
销售人员,
预约单号,
产品名称,
"预约金额(元)",
进账金额,
最后进账日期,
进账状态,
ROWNUM R
FROM (SELECT 客户号,
销售人员,
预约单号,
产品名称,
"预约金额(元)",
进账金额,
最后进账日期,
进账状态
FROM (SELECT QZKHID 客户号,
(SELECT RYXM FROM TRYXX WHERE ID = RYXX) 销售人员,
YYDH 预约单号,
CPMC 产品名称,
YYGMJE "预约金额(元)",
JZJE 进账金额,
JZRQ 最后进账日期,
CASE
WHEN JZJE = 0 THEN
'未进账'
WHEN YYGMJE - JZJE > 0 THEN
'部分进账'
ELSE
'全部进账'
END 进账状态
FROM (SELECT B.QZKHID,
B.RYXX,
B.YYDH,
C.CPMC,
B.YYGMJE,
SUM(A.JZJE) JZJE,
MAX(A.JZRQ) JZRQ
FROM TZJJZ A, TCPYY B, TFP_CPDM C
WHERE A.CPYYID = B.ID
AND A.CPID = C.ID
AND B.QZKHID = 327
GROUP BY B.QZKHID,
B.RYXX,
B.YYDH,
C.CPMC,
B.YYGMJE)
WHERE 1 = 1)
ORDER BY 1))
WHERE R BETWEEN 1 AND 6
查询潜在客户资金进账记录
最新推荐文章于 2019-12-30 15:31:39 发布