QUICK_PROF_VW

(SQL View)
 Index Back

Quick Customer Credit Cards

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

SELECT SETID , CONTACT_ID , EFFDT , CUSTOMER_SETID , CUST_ID , ' ' , CR_CARD_DIGITS , CR_CARD_TYPE , ' ' , ' ' , ' ' , ' ' , PRIMARY_CARD , PRIMARY_CARD , CR_CARD_VENDOR , CR_CARD_RQST_ID , CC_PROF_TOKEN , CC_RQST_TOKEN FROM PS_CONTACT_CARD WHERE CR_CARD_NBR = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
6 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
7 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
8 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

9 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
10 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
11 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
12 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
13 PRIMARY_CARD Character(1) VARCHAR2(1) NOT NULL Primary Card

Y/N Table Edit

Default Value: N

14 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
N=No
Y=Yes
15 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
16 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
17 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
18 CC_RQST_TOKEN Long Character(256) VARCHAR2(256) Request Token