CC_ISSUER_VW

(SQL View)
 Index Back

ProCard Credit Card Supplier


SELECT A.CREDIT_CARD_VENDOR , A.DESCR FROM PS_CC_CARD_TBL_EX A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CC_CARD_TBL_EX B WHERE B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn AND B.SETID = A.SETID AND B.CREDIT_CARD_VENDOR = A.CREDIT_CARD_VENDOR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description