RO_CARD_TYPE_VW

(SQL View)
 Index Back

Active Credit Card View

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

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

  • Related Language Record: RO_CR_TY_VW_LNG

    • # 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 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process