QUICK_TMP_VW

(SQL View)
 Index Back

Quick Customer Credit Cards

This record is used in capturing credit card data for the quick customer component.

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %TextIn(' ') FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
2 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
3 CR_CARD_TYPE Character(3) VARCHAR2(3) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute

Prompt Table: ORDENT_CCTYP_VW

4 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
5 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
6 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
7 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
8 PRIMARY_CARD Character(1) VARCHAR2(1) NOT NULL Primary Card

Y/N Table Edit

Default Value: N

9 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
N=No
Y=Yes
10 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
11 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
12 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
13 CC_RQST_TOKEN Long Character(256) VARCHAR2(256) Request Token