PV_MERCHANT_VW

(SQL View)
 Index Back

PV Merchants

This view identifies merchants that apply to PV.

SELECT A.MERCHANTID , A.EFFDT , A.DESCR , A.DESCRSHORT , A.MERCHINSTALLED , A.MRCHUIDTYPE , A.COMPANYID , A.CMPAUTHNTCTNTOKEN , A.RELATIONSHIPMNGR , A.RELMNGREMAIL , A.RELMNGRPHONENBR , A.MERCHWSITEURL , A.OBJECTOWNERID , A.MRCHIMAGENAME , C.PV_KEYWORDS , C.DESCR254_MIXED , D.MRCHAPPATTRVALUE FROM PSMERCHANTID A , PS_PV_MERCHANT C ,PSMERCHANTAPP D WHERE A.MERCHINSTALLED = 'Y' AND A.OBJECTOWNERID = 'DPV' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSMERCHANTID B WHERE A.MERCHANTID = B.MERCHANTID AND B.EFFDT <= %CurrentDateIn) AND C.EFFDT = A.EFFDT AND C.MERCHANTID = A.MERCHANTID AND D.EFFDT = A.EFFDT AND D.MERCHANTID = A.MERCHANTID AND D.MRCHAPPATTRNAME='CATEGORY_ID'

  • Related Language Record: PSMERCHANTIDLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 MERCHINSTALLED Character(1) VARCHAR2(1) NOT NULL Merchant Enabled

    Y/N Table Edit

    Default Value: N

    6 MRCHUIDTYPE Character(3) VARCHAR2(3) NOT NULL Merchant User ID Type
    CID=Company Identifier
    EID=Employee ID + Company ID
    EML=EMail Address
    OID=Operator ID + Company ID
    7 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    8 CMPAUTHNTCTNTOKEN Character(64) VARCHAR2(64) NOT NULL Company Authentication Token
    9 RELATIONSHIPMNGR Character(50) VARCHAR2(50) NOT NULL Relationship Manager
    10 RELMNGREMAIL Character(70) VARCHAR2(70) NOT NULL Relationship Manager Email
    11 RELMNGRPHONENBR Character(24) VARCHAR2(24) NOT NULL Relationship Manager Phone
    12 MERCHWSITEURL Character(254) VARCHAR2(254) NOT NULL Merchant Website URL
    13 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    14 MRCHIMAGENAME Character(30) VARCHAR2(30) NOT NULL Merchant Logo
    15 PV_KEYWORDS Character(254) VARCHAR2(254) NOT NULL Search Keywords
    16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    17 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID