AV_EP_BTCH2_AET

(SQL Table)
 Index Back

AV_EP_BATCH State Rec2

State record 2 for AV_EP_BATCH App Engine program.

# 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 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
5 MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL Merchant ID
6 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Credit Card Merchant ID
7 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
10 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
11 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
12 TRANSACTION_NO Character(14) VARCHAR2(14) NOT NULL Transaction Number
13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
14 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: AV_EXT_ORG_SRCH

15 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
16 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
17 DUES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Dues Amt
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type
20 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
21 AV_PAYMENT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment Status
A=Authorization Successful
B=Payment Captured
C=Refunded
D=Declined
M=Manually Approved/Settled
N=Payment Cancelled
P=Credit Card Credit Pending
V=Validated
22 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
23 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
24 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
25 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
26 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

Prompt Table: AV_CR_CARD_VW
Set Control Field: BUSINESS_UNIT

27 AV_CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL *Credit Card Number
28 AV_CR_CARD_NBR_E Character(44) VARCHAR2(44) NOT NULL Credit Card Number
29 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
30 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
31 CR_CARD_AUTH_DT Date(10) DATE Auth Date
32 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
33 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
34 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
35 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
36 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
37 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
01=Cybersource
02=TouchNet
99=Unsupported
38 SCC_EPAY_RET_MSG Character(254) VARCHAR2(254) NOT NULL Return Message
39 CR_CARD_MSG1 Character(50) VARCHAR2(50) NOT NULL Credit Card Message 1
40 CR_CARD_MSG2 Character(50) VARCHAR2(50) NOT NULL Credit Card Message2
41 CR_CARD_MSG3 Character(50) VARCHAR2(50) NOT NULL Credit Card Message3
42 CR_CARD_TRANS_REF Character(30) VARCHAR2(30) NOT NULL Transaction Reference Number
43 RETURN_STATUS Character(10) VARCHAR2(10) NOT NULL Return Status
44 AV_RECEIPT_NBR Character(12) VARCHAR2(12) NOT NULL Receipt Number
45 REFERENCE_NUM Character(15) VARCHAR2(15) NOT NULL Reference Number
46 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
47 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
48 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

49 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
50 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
51 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
52 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
53 CITY Character(30) VARCHAR2(30) NOT NULL City
54 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
55 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
56 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
57 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
58 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
59 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
60 COUNTY Character(30) VARCHAR2(30) NOT NULL County
61 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

62 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
63 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
64 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

65 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
66 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
67 CR_CARD_RQST_TOKN Long Character(256) VARCHAR2(256) Credit Card Request Token
68 SCC_EPAY_ORIGRSLT Signed Number(5,0) DECIMAL(4) NOT NULL Result Code
69 SCC_EPAY_TRSTATMSG Character(50) VARCHAR2(50) NOT NULL Status Message
70 SCC_EPAY_MERCH_REF Character(50) VARCHAR2(50) NOT NULL Merchant Reference
71 SCC_EPAY_CVRESULT Character(22) VARCHAR2(22) NOT NULL Credit Verification Result
72 SCC_EPAY_TRANS_REF Character(30) VARCHAR2(30) NOT NULL Transaction Reference Number