用友U8查询采购订单明细可付款申请金额

haichao118

于 2021-08-25 08:11:46 发布

阅读量5.8k

点赞数

分类专栏：用友文章标签： sql 数据库

本文链接：https://blog.csdn.net/haichao118/article/details/119902774

版权

用友专栏收录该内容

76 篇文章

订阅专栏

此SQL查询从多个表中检索数据，涉及采购订单（PO_Pomain, PO_Podetails）及付款申请单（AP_ApplyPayVouchs, AP_ApplyPayVouch）的相关信息。查询内容包括订单详细信息、采购订单本币价税合计、已申请付款金额等。通过子查询计算了针对采购订单和采购发票的付款申请单已申请金额，并筛选了特定ID的订单详情。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT * FROM dbo.PO_Pomain WHERE cPOID='IPO201116010'

SELECT ID FROM dbo.PO_Podetails WHERE POID='1000002351' AND cInvCode='CE0070030183'

SELECT PO_Podetails.iNatSum, --采购订单本币价税合计
-- @AppForPo =
(
SELECT SUM(AP_ApplyPayVouchs.iApplyAmt)
FROM AP_ApplyPayVouchs
JOIN dbo.AP_ApplyPayVouch
ON AP_ApplyPayVouchs.PID = AP_ApplyPayVouch.PID
AND AP_ApplyPayVouch.cSource = '采购订单'
WHERE AP_ApplyPayVouchs.iBVid = PO_Podetails.ID
-- AND AP_ApplyPayVouchs.AutoID != @AutoID
) AS AppForPo, --付款申请单参照采购订单已申请金额
--@AppForBill =
(
SELECT SUM(AP_ApplyPayVouchs.iApplyAmt)
FROM dbo.AP_ApplyPayVouch
JOIN dbo.AP_ApplyPayVouchs
ON AP_ApplyPayVouchs.PID = AP_ApplyPayVouch.PID
AND AP_ApplyPayVouch.cSource = '采购发票'
WHERE AP_ApplyPayVouchs.iPOsID = PO_Podetails.ID
-- AND AP_ApplyPayVouchs.AutoID != @AutoID
) AS AppForBill --付款申请单参照采购发票已申请金额
FROM dbo.PO_Pomain
JOIN dbo.PO_Podetails
ON PO_Podetails.POID = PO_Pomain.POID
WHERE PO_Podetails.ID IN('1000020722','1000020740','1000020752','1000020769','1000020781','1000020793','1000020807','1000020827','1000020843','1000020856','1000020870','1000020890')