MERCHANTIDPrompt Table: BN_M_MERCH_SRCH
BN_M_MERCH_SRCH(SQL View) |
Index Back |
|---|---|
Search for Merchants InstalledSELECT MERCHANTID FROM PSMERCHANTID WHERE MERCHINSTALLED ='Y' |
| SELECT A.MERCHANTID , A.DESCR FROM PSMERCHANTID A , PSMERCHANTCAT B WHERE A.MERCHANTID = B.MERCHANTID AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSMERCHANTID A1 WHERE A1.MERCHANTID = A.MERCHANTID AND A1.EFFDT <= %CurrentDateIn) AND A.EFFDT = B.EFFDT AND B.MERCHANTCAT = 'CAR_INT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL |
Merchant ID
Prompt Table: BN_M_MERCH_SRCH |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |