SSF_PMT_LOGM_VW

(SQL View)
 Index Back

SF Payment Log Misc View

View of the SF Payment Log used for Miscellaneous Purchases.

SELECT A.COMMON_ID , A.SA_ID_TYPE , A.SF_PMT_REF_NBR , A.sequence_nbr_3 , A.SF_PAYMENT_STATUS FROM PS_SF_PAYMENT_LOG A WHERE A.SEQUENCE_NBR_3 = ( SELECT MAX(B.SEQUENCE_NBR_3) FROM PS_SF_PAYMENT_LOG B WHERE A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.SF_PMT_REF_NBR = B.SF_PMT_REF_NBR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
3 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
4 SEQUENCE_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence Nbr
5 SF_PAYMENT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment Status
A=Authorization Successful
B=Payment Completed
C=Refunded
D=Declined
E=Edit Error
I=Payment Initiated
M=Manually Approved/Settled
N=Payment Cancelled
P=Credit Pending
R=Refund Cancelled
S=Payment Submitted