使用以下示例代码来检查Amdocs计费是否正确:
SELECT
po.ORDER_NUMBER,
SUM(pod.PRICE * pod.QUANTITY) AS TOTAL_PRICE,
SUM(pod.SHIPPING_PRICE * pod.QUANTITY) AS TOTAL_SHIPPING_PRICE,
SUM(pod.INSURANCE_PRICE * pod.QUANTITY) AS TOTAL_INSURANCE_PRICE,
SUM(pod.PRICE * pod.QUANTITY) + SUM(pod.SHIPPING_PRICE * pod.QUANTITY) + SUM(pod.INSURANCE_PRICE * pod.QUANTITY) AS GRAND_TOTAL_PRICE
FROM
PURCHASE_ORDER po
INNER JOIN PURCHASE_ORDER_DETAIL pod ON po.ORDER_NUMBER = pod.ORDER_NUMBER
WHERE
po.CUSTOMER_ID = '12345'
AND po.ORDER_DATE BETWEEN '2019-01-01' AND '2019-12-31'
GROUP BY
po.ORDER_NUMBER
此代码将检索在2019年1月1日至2019年12月31日之间针对客户ID为12345的所有订单的总价格,总运费和总保险费用,并计算总费用。如果有任何差异或错误,请检查Amdocs计费以确认正确性。
上一篇:amd拿什么对抗cuda