MERCH_ENABLE_VW

(SQL View)
 Index Back

Active Merchant View

Used to enforce the business rule that merchants can only be used by PeopleSoft if they have been "Activated." Collects data from PSMERCHANTID.

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.MRCHIMAGENAME , A.OBJECTOWNERID FROM PSMERCHANTID A , PSMERCHANTCAT B WHERE A.MERCHINSTALLED = 'Y' AND %Join(COMMON_KEYS, PSMERCHANTID A, PSMERCHANTCAT B) AND B.MERCHANTCAT = 'ADMIN' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSMERCHANTID C WHERE A.MERCHANTID = C.MERCHANTID)

  • 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 MRCHIMAGENAME Character(30) VARCHAR2(30) NOT NULL Merchant Logo
    14 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier