AP_VCHR_PAID_VW (SQL View)	Index Back
Sum amnt paid or selct voucher This view is used in voucher inquiry component

AP_VCHR_PAID_VW

(SQL View)

Sum amnt paid or selct voucher

This view is used in voucher inquiry component

SELECT C.BUSINESS_UNIT , C.VOUCHER_ID , SUM(CASE WHEN PYMNT_SELCT_STATUS = 'S' OR PYMNT_SELCT_STATUS = 'P' THEN C.PYMNT_GROSS_AMT ELSE 0 END) , SUM(CASE WHEN C.PAID_AMT_BSE <> C.PAID_AMT_GROSS_BSE AND (PYMNT_SELCT_STATUS = 'S' OR PYMNT_SELCT_STATUS = 'P') THEN C.PAID_AMT_DSCNT ELSE 0 END) FROM PS_PYMNT_VCHR_XREF C GROUP BY c.BUSINESS_UNIT , c.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 CONV_GROSS_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Used for Voucher Inquiry view to hold the paid amounts converted to the txn currency of the voucher.

4 CONV_DSCNT_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Used for Voucher Inquiry to hold the Discount Paid converted to the voucher txn currency.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	CONV_GROSS_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used for Voucher Inquiry view to hold the paid amounts converted to the txn currency of the voucher.
4	CONV_DSCNT_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used for Voucher Inquiry to hold the Discount Paid converted to the voucher txn currency.