FS_CR_CARD_VW

(SQL View)
Index Back

Credit Card Type View

This view is used on the OM Order Entry form to find the valid Credit Card Types audits. Date Init. Issue # Description 031505 RR 1218176002 Modified SQL by using EOEC_CCI_TYPE so that credit card type on contact additional information page referred to the correct table. 080409 JJM 1905864000 Created Rel Lang View

SELECT EOEC_CCI_TYPE , EOEC_CCI_NAME , EOEC_CCI_LENGTH , EOEC_CCI_TYPESTAT , EOEC_CCI_PREFIX , EOEC_CCI_CHKDIGIT , EOEC_CCI_EXPDAYS , EOEC_CCI_NAME FROM PS_EOEC_CCI_TYPE WHERE EOEC_CCI_TYPESTAT = 'A'

  • Related Language Record: ORDENT_CCTP_LNG
  • # 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 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Credit Card Name
    3 CR_CARD_LENGTH Number(3,0) SMALLINT NOT NULL Credit Card Number Length
    4 CR_CARD_STAT Character(1) VARCHAR2(1) NOT NULL Credit Card Status
    A=Active Credit Card
    I=Inactive Credit Card
    5 CR_CARD_PREFIX Character(60) VARCHAR2(60) NOT NULL Credit Card Valid Prefixes
    6 USE_CHECK_DIGIT Character(1) VARCHAR2(1) NOT NULL Use Check Digit Algorithm
    N=No
    Y=Yes

    Default Value: N

    7 CR_CARD_EXP_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Credit Card Expiration Days
    8 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field