SCM_GRP_TYPE_VW

(SQL View)
 Index Back

Credit Card Group Types View

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

SELECT SCM.SCM_CCI_GROUP , SCM.CR_CARD_TYPE , TYP.EOEC_CCI_NAME FROM PS_SCM_CCI_GROUP SCM , PS_EOEC_CCI_TYPE TYP WHERE SCM.CR_CARD_TYPE = TYP.EOEC_CCI_TYPE

  • Related Language Record: SCM_GRP_TYPE_LN

    • # 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

    Prompt Table: SCM_CCI_TYPE_VW

    3 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Credit Card Name