PMT_DASH_VW2

(SQL View)

SELECT pmt_source , pmt_status , SUM(amount) FROM PS_PMT_DETAIL_TBL GROUP BY pmt_source , pmt_status

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PMT_SOURCE Character(10) VARCHAR2(10) NOT NULL Source System Name

2 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

3 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source System Name
2	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
3	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount