MERCHANTIDEFFDTDefault Value: %date
IONAMEPrompt Table: PSIODEFN_VW
IOLINENUMDefault Value: 1
0=Disable
1=Enable
Y/N Table Edit
Default Value: N
CO_MERBIPRMS_VW(SQL View) |
Index Back |
|---|---|
Merchant BI ViewSelecting values form PSMERCHBIPARMS . |
| SELECT D.MERCHANTID , D.EFFDT , D.IONAME , D.IOLINENUM , D.REQUIRED , D.OVERRIDEDFLTVALUE , D.IOSETTINGNAME , D.IOVALUE FROM PSMERCHBIPARMS D WHERE D.OVERRIDEDFLTVALUE = 'Y' AND D.EFFDT = ( SELECT MAX(A.EFFDT) FROM PSMERCHBIPARMS 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 | IOLINENUM |
Number(4,0) | SMALLINT NOT NULL |
Interface Object Line Number
Default Value: 1 |
| 5 | REQUIRED | Character(8) | VARCHAR2(8) NOT NULL | Required |
| 6 | OVERRIDEDFLTVALUE | Character(1) | VARCHAR2(1) NOT NULL |
Can Over-Ride Defualt Value
0=Disable 1=Enable Y/N Table Edit Default Value: N |
| 7 | IOSETTINGNAME | Character(254) | VARCHAR2(254) NOT NULL | Interface Object Setting Name |
| 8 | IOVALUE | Character(128) | VARCHAR2(128) NOT NULL | Interface Object Value |