SCM_CCI_TYPE_LN

(SQL View)
Index Back

Credit Card Types Lang

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

SELECT %Substring(EOEC_CCI_TYPE, 1, 2) , LANGUAGE_CD , EOEC_CCI_NAME FROM PS_EOEC_CCI_TP_LNG

  • Related Language Record for SCM_CCI_TYPE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Credit Card Name