SCM_GRP_TYPE_LN

(SQL View)
 Index Back

Credit Card Group Types Lang

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

SELECT SCM.SCM_CCI_GROUP , SCM.CR_CARD_TYPE , LNG.LANGUAGE_CD , LNG.EOEC_CCI_NAME FROM PS_SCM_CCI_GROUP SCM , PS_EOEC_CCI_TP_LNG LNG WHERE SCM.CR_CARD_TYPE = LNG.EOEC_CCI_TYPE

  • Related Language Record for SCM_GRP_TYPE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Credit Card Name