PO_SSVNDRBAL_VW

(SQL View)

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.TXN_CURRENCY_CD , SUM(B.PYMNT_GROSS_AMT) , SUM(B.DSCNT_PAY_AMT) FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B , PS_VENDOR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.ENTRY_STATUS = 'P' AND B.PYMNT_SELCT_STATUS = 'N' AND A.VENDOR_SETID = C.SETID AND A.VENDOR_ID = C.VENDOR_ID GROUP BY A.TXN_CURRENCY_CD, A.VENDOR_ID, A.VENDOR_SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

4 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

5 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
4	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
5	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount