GLRCN_AP_PAY_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.ACCOUNTING_DT , B.PYMNT_CNT , B.PYMNT_ID , B.DUE_DT , B.PYMNT_SELCT_STATUS , B.PYMNT_HOLD , C.PYMNT_AMT , C.CURRENCY_PYMNT , C.PYMNT_STATUS , C.POST_STATUS_AP FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B , PS_PAYMENT_TBL C WHERE C.POST_STATUS_AP='U' AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND B.PYMNT_ID = C.PYMNT_ID AND B.BANK_SETID = C.BANK_SETID AND B.BANK_CD = C.BANK_CD AND B.BANK_ACCT_KEY = C.BANK_ACCT_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUS_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Default Value: NEXT

3 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
Default Value: 1

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

6 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

7 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
Default Value: N

8 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes
Y/N Table Edit
Default Value: N

9 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

10 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency
Prompt Table: CURR_PYMNT_VW

11 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted

12 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUS_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
4	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments Default Value: 1
5	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
6	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
7	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 Default Value: N
8	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes Y/N Table Edit Default Value: N
9	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
10	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Prompt Table: CURR_PYMNT_VW
11	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted
12	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U