MERCHANTIDCID=Company Identifier
EID=Employee ID + Company ID
EML=EMail Address
OID=Operator ID + Company ID
CO_MERCH_VW(SQL View) |
Index Back |
|---|---|
PSMERCHANT ViewView to retrieve the information from PSMERCHANTID table. |
| SELECT D.MERCHANTID , D.EFFDT , D.DESCR , D.MERCHINSTALLED , D.MRCHUIDTYPE , D.COMPANYID , D.CMPAUTHNTCTNTOKEN , D.MERCHWSITEURL FROM PSMERCHANTID D WHERE D.MERCHINSTALLED = 'Y' AND D.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSMERCHANTID A WHERE A.MERCHANTID = D.MERCHANTID AND A.EFFDT <=%CurrentDateIn) |
| # | 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 | Effective Date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | MERCHINSTALLED | Character(1) | VARCHAR2(1) NOT NULL | Merchant Enabled |
| 5 | 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 |
| 6 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 7 | CMPAUTHNTCTNTOKEN | Character(64) | VARCHAR2(64) NOT NULL | Company Authentication Token |
| 8 | MERCHWSITEURL | Character(254) | VARCHAR2(254) NOT NULL | Merchant Website URL |