22,301
社区成员




round(CAST(
(CASE WHEN 计款方式 = '收费' THEN
CASE WHEN dbo.客户.下订单 = '-1' THEN
CASE WHEN 正品 + 备品 > PO量 THEN
Case when 进出性质.性质名称='样板(收费)A' then
round(PO量 * CAST(COALESCE (round(dbo.送货单明细.单价,3),0) AS NUMERIC(10, 3)), 3)
ELSE
round((正品 + 备品)* CAST(COALESCE (round(dbo.送货单明细.单价, 3),0) AS NUMERIC(10, 3)), 3)
END ELSE
round((dbo.送货单明细.正品 + 备品)* CAST(COALESCE (round(dbo.送货单明细.单价, 3),0) AS NUMERIC(10, 3)),3)
End else
round(dbo.送货单明细.单价, 3)
END ELSE 0 END)
AS numeric(10, 3)),3) AS 应收金额
case when 计款方式 = '收费'
then case
when 进出性质.性质名称='样板(收费)A' --> 金额=公式B
when dbo.客户.下订单 = '-1' --> 金额=公式C
when 正品 + 备品 > PO量 --> 金额=公式D
end
else 0
end
case when 计款方式 <> '收费' then 0 else
case
when 进出性质.性质名称='样板(收费)A' --> 金额=公式B
when dbo.客户.下订单 = '-1' --> 金额=公式C
when 正品 + 备品 > PO量 --> 金额=公式D
end
end
round(CAST(
(case when 计款方式 = '收费' and 进出性质.性质名称='样板(收费)A' THEN
round(dbo.送货单明细.单价, 3)
WHEN (计款方式 = '收费') and (dbo.客户.下订单 = '-1') and ( 正品 + 备品 > PO量) and (进出性质.性质名称<>'样板(收费)A')THEN
round((正品 + 备品)* CAST(COALESCE (round(dbo.送货单明细.单价, 3),0) AS NUMERIC(10, 3)), 3)
WHEN 计款方式 = '收费' and (dbo.客户.下订单 <> '-1') and (进出性质.性质名称<>'样板(收费)A') THEN
round((dbo.送货单明细.正品 + 备品)* CAST(COALESCE (round(dbo.送货单明细.单价, 3),0) AS NUMERIC(10, 3)),3)
ELSE 0 END)
AS numeric(10, 3)),3) AS 应收金额