VNDR_PYINQ_VW5D

(SQL View)
 Index Back

Supplier Payment Inquiry View

Supplier Payment Inquiry View

SELECT A.SETID , A.VENDOR_ID , R.TO_CUR , A.BUSINESS_UNIT , A.VENDOR_NAME_SHORT , A.NAME1 , SUM(A.PYMNT_GROSS_AMT) , TXN_CURRENCY_CD , SUM(%Round(%DecMult(%DecDiv(A.PYMNT_GROSS_AMT, R.RATE_DIV), R.RATE_MULT), C.DECIMAL_POSITIONS)) FROM PS_VNDR_PYINQ_VW1 A , PS_RT_RATE_TBL R , PS_CURRENCY_CD_TBL C WHERE A.VCHR_DUE_DT < %CurrentDateIn AND A.PYMNT_SELCT_STATUS NOT IN ('P', 'X', 'C', 'S') 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 = A.TXN_CURRENCY_CD AND R.RT_TYPE = A.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 A.SETID , A.VENDOR_ID , R.TO_CUR, A.BUSINESS_UNIT , A.VENDOR_NAME_SHORT , A.NAME1 , A.TXN_CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL 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

Prompt Table: SP_BU_AP_NONVW

5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
8 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
9 CONV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount