Used as prompt to fetch the prepaid reference of prepaid voucher

PPAY_VCHR_VW

(SQL View)

SELECT a.business_unit , a.vendor_setid , a.vendor_id , a.txn_currency_cd , a.voucher_id , a.PREPAID_REF , b.vendor_name_short , a.gross_amt , a.txn_currency_cd , a.invoice_id , a.invoice_dt FROM PS_VOUCHER a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND A.VOUCHER_STYLE = 'PPAY' AND A.ENTRY_STATUS<>'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

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

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

6 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference

7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

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

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

11 INVOICE_DT Date(10) DATE Invoice Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
5	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	PREPAID_REF	Character(10)	VARCHAR2(10) NOT NULL	Prepayment Reference
7	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
8	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
11	INVOICE_DT	Date(10)	DATE	Invoice Date