SCM_CCI_GRP_VW

(SQL View)
 Index Back

Credit Card Groups View

Date Init Issue Description 110110 JJM F-CROSS-92-ALL-08 Credit Card Tokenization

SELECT SCM_CCI_GROUP , CR_CARD_TYPE , CR_CARD_VENDOR FROM PS_SCM_CCI_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCM_CCI_GROUP Character(15) VARCHAR2(15) NOT NULL Credit Card Group
2 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
3 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name