REFUND_EPYMT_VW

(SQL View)
 Index Back

SELECT BUSINESS_UNIT , REFUND_NBR , LINE_SEQ_NBR , SF_PMT_REF_NBR , SEQNUM , COMMON_ID , SA_ID_TYPE , SF_PAYMENT_STATUS , SF_POST_STATUS , INSTITUTION_SET , PAYMENT_AMT , STRM , DUE_DT , CR_CARD_EXPMO , CR_CARD_EXPYR , CR_CARD_FNAME , CR_CARD_LNAME , CR_CARD_NBR , CR_CARD_TYPE , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , EMAIL_ADDR , PHONE , CR_CARD_AUTH_CD , CR_CARD_AUTH_DT , CR_CARD_RQST_ID , CR_CARD_A_DTTM , CR_CARD_AUTH_REPLY , CR_CARD_TRANS_LAST , CR_CARD_AVS_CD , PROCESS_INSTANCE , CURRENCY_CD , SF_PAYMENT_SPLIT , OPRID , CR_CARD_DIGITS , SF_REVERSAL_IND , POSTED_DATE , POSTED_DATETIME , MESSAGE_SET_NBR , MESSAGE_NBR , SSF_ERROR_WARN , BUSINESS_UNIT_ERR , LAST_DTTM_UPDATE , BATCH_ID , CR_CARD_TRANS_SRC , REVERSAL_STAT_SF , CASHIER_OFFICE , SF_REGISTER , RECEIPT_NBR , SF_MERCHANT_ID , RECEIPT_LINE_NBR , ADM_APPL_NBR , INSTITUTION , ADM_APPL_CTR , CR_CARD_SRVC_PROV , TRANS_REF_NO , TENDER_CATEGORY , BANK_ACCT_TYP , BANK_CD , SSF_BNK_ACCT_NUM , EC_SETTLE_METHOD , EC_VERIFICATION FROM PS_SF_PAYMENT WHERE REFUND_NBR <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
3 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
4 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
7 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
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

Prompt Table: INSTITUTION_SET

11 PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
12 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

13 DUE_DT Date(10) DATE Expected Birth Date
14 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
15 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
16 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
17 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
18 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
19 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

Prompt Table: CR_CARD_TYPE_VW

20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
25 CITY Character(30) VARCHAR2(30) NOT NULL City
26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
33 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

37 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
38 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
39 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
40 CR_CARD_AUTH_DT Date(10) DATE Auth Date
41 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
42 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
43 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
44 CR_CARD_TRANS_LAST Character(2) VARCHAR2(2) NOT NULL Transaction Requested
1=Authorize
2=Authorize and Capture
3=Capture
4=Credit
5=eCheck Debit
6=eCheck Credit
91=Request Token
92=Authorize and Capture
93=Hosted Payment Credit
45 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
46 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
47 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
48 SF_PAYMENT_SPLIT Character(1) VARCHAR2(1) NOT NULL Payment Allocated

Y/N Table Edit

49 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
50 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
51 SF_REVERSAL_IND Character(1) VARCHAR2(1) NOT NULL Reversal Indicator
52 POSTED_DATE Date(10) DATE Date Posted
53 POSTED_DATETIME DateTime(26) TIMESTAMP Posted Date & Time
54 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
55 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
56 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
E=Error
M=Message
W=Warning
57 BUSINESS_UNIT_ERR Character(5) VARCHAR2(5) NOT NULL Business Unit
58 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.
59 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
60 CR_CARD_TRANS_SRC Character(1) VARCHAR2(1) NOT NULL Payment Transaction Source
A=Application Center
C=Cashiering
I=Contributor Relations
M=Miscellaneous Fees
P=Payment
R=Refund
V=Payment Reversal
61 REVERSAL_STAT_SF Character(1) VARCHAR2(1) NOT NULL Reversal Status
E=Errors were encountered
S=Successful
62 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
63 SF_REGISTER Character(5) VARCHAR2(5) NOT NULL Cash Register
64 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
65 SF_MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL SF Merchant ID
66 RECEIPT_LINE_NBR Number(3,0) SMALLINT NOT NULL Receipt Line Number
67 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
68 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

69 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
70 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
71 TRANS_REF_NO Character(60) VARCHAR2(60) NOT NULL Transaction Reference Nbr
72 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
73 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
74 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
75 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
76 EC_SETTLE_METHOD Character(1) VARCHAR2(1) NOT NULL Settlement Method
A=Automated Clearing House
B=Best possible
F=Facsimile draft
77 EC_VERIFICATION Character(1) VARCHAR2(1) NOT NULL Verification Level
1=Validation
2=Verification