RB_CCWIPE_RECVW

(SQL View)
 Index Back

Credit Card transaction table

Credit Card transaction table list

SELECT A.RECNAME , B.FIELDNAME , A.RECDESCR FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME=B.RECNAME AND A.RECTYPE=0 AND A.RECNAME NOT LIKE '%_AET' AND A.RECNAME<>'RB_CREDIT_CARD' AND B.FIELDNAME IN ('CR_CARD_NBR') UNION SELECT A.RECNAME , B.FIELDNAME , A.RECDESCR FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME=B.RECNAME AND A.RECTYPE=0 AND A.RECNAME NOT LIKE '%_AET' AND A.RECNAME<>'RB_CREDIT_CARD' AND B.FIELDNAME IN ( SELECT A.RECNAME FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME=B.RECNAME AND A.RECTYPE=3 AND B.FIELDNAME IN ('CR_CARD_NBR') )

  • Related Language Record: PSRECDEFNLANG1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description