RO_CR_TY_VW_LNG

(SQL View)
 Index Back

Active Cred Card View

Displays credit cards that the system considers active and available for use.

SELECT a.BUSINESS_UNIT , b.EOEC_CCI_TYPE , c.LANGUAGE_CD , c.EOEC_CCI_NAME FROM %Table(BU_TBL_RO_CC) a , %Table(EOEC_CCI_TYPE) b , %Table(EOEC_CCI_TP_LNG) c WHERE a.CR_CARD_TYPE = b.EOEC_CCI_TYPE AND a.CR_CARD_TYPE = c.EOEC_CCI_TYPE AND b.EOEC_CCI_TYPESTAT = 'A'

  • Related Language Record for RO_CARD_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL "See OM
    01=Visa
    02=MasterCard
    03=Diners Club/Carte Blanche
    04=AMEX
    05=Discover
    06=EnRoute
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process