AP_DISCTAKE_VW2

(SQL View)
 Index Back

Discount Taken View

Discount Taken View

SELECT B.VENDOR_SETID , B.VENDOR_ID , R.TO_CUR , B.BUSINESS_UNIT , B.TXN_CURRENCY_CD , SUM(A.DSCNT_PAY_AMT) , SUM(%Round(%DecMult(%DecDiv(A.DSCNT_PAY_AMT, R.RATE_DIV), R.RATE_MULT), C.DECIMAL_POSITIONS)) FROM PS_PYMNT_VCHR_XREF A , PS_VOUCHER B , PS_RT_RATE_TBL R , PS_CURRENCY_CD_TBL C , PS_PAYMENT_TBL P WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.PYMNT_ID = P.PYMNT_ID AND ((A.PAID_AMT_GROSS - A.PAID_AMT) = A.PAID_AMT_DSCNT) AND A.DSCNT_PAY_AMT > 0 AND P.CANCEL_ACTION NOT IN ('C','H','R','S','W') AND R.RT_RATE_INDEX = ( SELECT RT_RATE_INDEX FROM PS_RT_INDEX_TBL WHERE DEFAULT_INDEX = 'Y') AND R.TERM = 0 AND R.FROM_CUR = B.TXN_CURRENCY_CD AND R.RT_TYPE = B.RT_TYPE AND R.EFFDT = ( SELECT MAX(R_ED.EFFDT) FROM PS_RT_RATE_TBL R_ED WHERE R.RT_RATE_INDEX = R_ED.RT_RATE_INDEX AND R.TERM = R_ED.TERM AND R.FROM_CUR = R_ED.FROM_CUR AND R.TO_CUR = R_ED.TO_CUR AND R.RT_TYPE = R_ED.RT_TYPE AND R_ED.EFFDT <= %CurrentDateIn) AND C.CURRENCY_CD = R.TO_CUR AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_CURRENCY_CD_TBL C2 WHERE C2.CURRENCY_CD = C.CURRENCY_CD AND C2.EFFDT <= %CurrentDateIn) GROUP BY B.VENDOR_SETID, B.VENDOR_ID, R.TO_CUR, B.BUSINESS_UNIT, B.TXN_CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
7 CONV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount