ORDENT_CCTP_LNG

(SQL View)
 Index Back

Credit Card Types Lang

This record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other suppliers. Date Init. Issue # Description 080409 JJM 1905864000 Created Rel Lang View

SELECT %Substring(A.EOEC_CCI_TYPE, 1, 2) , B.LANGUAGE_CD , B.EOEC_CCI_NAME FROM PS_EOEC_CCI_TYPE A , PS_EOEC_CCI_TP_LNG B WHERE A.EOEC_CCI_TYPE=B.EOEC_CCI_TYPE

  • Related Language Record for FS_CR_CARD_VW ORDENT_CCTYP_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