EM_PYMNT_IN_VW2 (SQL View)	Index Back
Voucher Inquiry Retreiving Vie This view is used by the Market Pay Module to retrieve all of the PYMNT_VCHR_XREF rows that have a payment made on them. It, in turn, is used on the Vouchers Inquiries panel group to determine if the payment information button should appear. The view and processing logic for it can be removed if scheduled payments are used in the module - the logic will then have to direct the user to the ..... rather than the payment information panel.

EM_PYMNT_IN_VW2

(SQL View)

Voucher Inquiry Retreiving Vie

This view is used by the Market Pay Module to retrieve all of the PYMNT_VCHR_XREF rows that have a payment made on them. It, in turn, is used on the Vouchers Inquiries panel group to determine if the payment information button should appear. The view and processing logic for it can be removed if scheduled payments are used in the module - the logic will then have to direct the user to the ..... rather than the payment information panel.

SELECT DISTINCT a.business_unit , c.oprid , a.voucher_id , d.pymnt_cnt , d.bank_setid , d.bank_cd , d.bank_acct_key , d.pymnt_method , d.pymnt_id , d.pymnt_hold , d.pymnt_selct_status FROM PS_VOUCHER a , ps_vendor b , ps_sec_bu_opr c , ps_pymnt_vchr_xref d WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.business_unit = c.business_unit AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND d.pymnt_selct_status = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_AP_NONVW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

5 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

7 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

8 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

9 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

10 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes

11 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AP_NONVW
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
5	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
6	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
7	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
8	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
9	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
10	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes
11	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid