SF_PAYMENT_PEND

(SQL View)
 Index Back

SF electronic payments - pend

View of all pending electronic payments

SELECT SF_PMT_REF_NBR , COMMON_ID , SA_ID_TYPE , PAYMENT_AMT , currency_cd , LAST_DTTM_UPDATE , CR_CARD_DIGITS , SF_PAYMENT_STATUS , SF_POST_STATUS , INSTITUTION_SET , TENDER_CATEGORY FROM PS_SF_PAYMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SF_PMT_REF_NBR2 Character(12) VARCHAR2(12) NOT NULL Reference Nbr
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 PAYMENT_AMT_SF Number(18,2) DECIMAL(17,2) NOT NULL Payment Amount
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
8 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
9 SF_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Posting Status
E=Errors Encountered.
P=Pending
S=Successfully Posted
10 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
11 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer