MERCHANTIDEFFDTDefault Value: %date
IONAMEPrompt Table: PSIODEFN_VW
Y/N Table Edit
Default Value: N
CO_MERCHBI_VW(SQL View) |
Index Back |
|---|---|
Merchant BI ViewSelecting from PSMERCHBI. |
| SELECT D.MERCHANTID , D.EFFDT , D.IONAME , D.SIGNONBI FROM PSMERCHBI D WHERE D.SIGNONBI = 'Y' AND D.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSMERCHBI 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 NOT NULL |
Effective Date
Default Value: %date |
| 3 | IONAME |
Character(30) | VARCHAR2(30) NOT NULL |
Interface Object Name (see PSIODEFN).
Prompt Table: PSIODEFN_VW |
| 4 | SIGNONBI | Character(1) | VARCHAR2(1) NOT NULL |
Sign-On Business Interlink
Y/N Table Edit Default Value: N |