CNTCT_CARD_VW

(SQL View)
 Index Back

Contact Card Information View

View is used when determining which valid credit card to use for the Customer Contact.

SELECT c.setid , c.cust_id , c.cntct_seq_num , c.cr_card_type , c.cr_card_nbr , c.cr_card_fname , c.cr_card_lname , c.cr_card_expmo , c.cr_card_expyr , c.cr_card_digits FROM PS_CUST_CNTCT_CARD c WHERE %EffdtCheck(cust_cntct_card c2, c, %CurrentDateIn)

  • Parent record: CUST_CNTCT_SEQ

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    4 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

    Prompt Table: ORDENT_CCTYP_VW

    5 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
    6 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    7 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    8 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
    01=January
    02=February
    03=March
    04=April
    05=May
    06=June
    07=July
    08=August
    09=September
    10=October
    11=November
    12=December
    9 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
    2011=2011
    2012=2012
    2013=2013
    2014=2014
    2015=2015
    2016=2016
    2017=2017
    2018=2018
    2019=2019
    2020=2020
    10 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits