VCHR_INQ_PDDS_V (SQL View)	Index Back
Voucher Inquiry Work View Voucher Inquiry Work View

VCHR_INQ_PDDS_V

(SQL View)

Voucher Inquiry Work View

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , SUM(B.PYMNT_GROSS_AMT) , SUM(B.DSCNT_PAY_AMT) FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VOUCHER_STYLE <> 'PPAY' AND A.ENTRY_STATUS <> 'X' AND B.PYMNT_SELCT_STATUS IN ('P', 'S') AND B.PAID_AMT_BSE <> B.PAID_AMT_GROSS_BSE GROUP BY A.BUSINESS_UNIT, A.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.