SF_PMT_TEST_AET

(SQL Table)
 Index Back

State record for SF Payment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Credit Card Merchant ID
5 CR_CARD_IP Character(15) VARCHAR2(15) NOT NULL Credit Card IP Override
6 CR_CARD_SERVER Character(28) VARCHAR2(28) NOT NULL Credit Card Processing Server
7 CR_CARD_RISK Character(1) VARCHAR2(1) NOT NULL Perform Check Risk Service

Y/N Table Edit

Default Value: N

8 CR_CARD_AVS Character(1) VARCHAR2(1) NOT NULL Address Verification Flag
N=Address Verification Off
Y=Address Verification On

Default Value: N

9 PAYMENT_AMT Number(19,3) DECIMAL(18,3) NOT NULL Payment Amount
10 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
11 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
12 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
13 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
14 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
15 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

Prompt Table: CR_CARD_TYPE_VW

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

Prompt Table: SCC_CNT_ADFMTVW

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

Prompt Table: STATE_TBL

30 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
31 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
32 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

33 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
34 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
35 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
36 CR_CARD_AUTH_DT Date(10) DATE Auth Date
37 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
38 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
39 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
40 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
41 CR_CARD_ERRMSG Character(30) VARCHAR2(30) NOT NULL Credit Card Error Message
42 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
44 SF_BI_RET_STATUS Character(10) VARCHAR2(10) NOT NULL Return Status
45 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
46 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
47 DESCR100_2 Character(100) VARCHAR2(100) NOT NULL Description
48 DESCR100_3 Character(100) VARCHAR2(100) NOT NULL Description
49 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
50 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID
51 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
C=Checking
S=Savings
52 TRANS_REF_NO Character(60) VARCHAR2(60) NOT NULL Transaction Reference Nbr
53 CR_CARD_RQST_TOKN Long Character(256) VARCHAR2(256) Credit Card Request Token
54 SCC_EPAY_CVNUM Character(4) VARCHAR2(4) NOT NULL Card Verification Number
55 SCC_EPAY_CHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Check number.
56 SCC_MERCHANT_ID Character(16) VARCHAR2(16) NOT NULL Payment Merchant ID

Prompt Table: SCC_MERCHANT

57 SCC_EPAY_TRANSACT Character(2) VARCHAR2(2) NOT NULL Indicator for Electronic Payment Transaction Type.
1=Authorize Only (CC)
10=Adjust Amount (CC)
11=Get Status (CC)
12=Validate Card (CC)
13=Authorization Reversal (CC)
2=Authorize and Bill (CC)
3=Bill Only (CC)
30=Void Payment (ACH)
31=Get Agreement (ACH)
32=Save Agreement (ACH)
33=Validate Routing (ACH)
4=Credit Only (CC)
5=Make Payment (ACH)
6=Apply Credit (ACH)
91=Get Token (HPay)
92=Authorize Only (HPay)
93=Credit Only (HPay)
58 SCC_EPAY_RESULT Signed Number(5,0) DECIMAL(4) NOT NULL Result Code
59 SCC_EPAY_ORIGRSLT Signed Number(5,0) DECIMAL(4) NOT NULL Result Code
60 SCC_EPAY_RET_MSG Character(254) VARCHAR2(254) NOT NULL Return Message
61 SCC_EPAY_AUTHCD Character(10) VARCHAR2(10) NOT NULL Authorization code
62 SCC_EPAY_DECISION Character(30) VARCHAR2(30) NOT NULL Decision
63 SCC_EPAY_TRSTAT Signed Number(5,0) DECIMAL(4) NOT NULL Return status
64 SCC_EPAY_TRSTATMSG Character(50) VARCHAR2(50) NOT NULL Status Message