PMT_DASH_VW1

(SQL View)

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 AMOUNT_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

3 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

4 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	AMOUNT_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
3	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
4	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount