PV_PORTAL_XREF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PV_MP_SWITCH |
Character(3) | VARCHAR2(3) NOT NULL |
Select a Main Page
BS=Buyer Station CM=Supplier Content Management CMC=Catalog Management CO=Cohera PV=eProcurement SP=sProcurement Homepage Default Value: PV_MP_SELECT.PV_MP_SWITCH |
| 2 | MAINPAGEITEMNUMBER |
Number(3,0) | SMALLINT NOT NULL | Main Page Item Number |
| 3 | MAINPAGEITEMBGIMG | Character(99) | VARCHAR2(99) NOT NULL | Main Page Item Image |
| 4 | MAINPAGEITEMTITLE | Character(100) | VARCHAR2(100) NOT NULL | Main Page Item |
| 5 | MAINPGEITEMIMAGE | Character(100) | VARCHAR2(100) NOT NULL | Title Image |
| 6 | PV_MP_BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Bar Name |
| 7 | PV_MP_ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 8 | PV_MP_PAGENAME | Character(30) | VARCHAR2(30) NOT NULL | Starting Page |
| 9 | PV_MP_TITLE_PSTN | Character(3) | VARCHAR2(3) NOT NULL |
Image Position
BL=Bottom Left BR=Bottom Right TL=Top Left TR=Top Right |
| 10 | PV_MP_MSG_SET_NBR | Number(9,0) | DECIMAL(9) NOT NULL |
Message Set Number
Default Value: 18036 |
| 11 | PV_MP_TTL_MSG_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Title Message Number |
| 12 | PV_MP_MSG_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Message Number |
| 13 | CREFURL | Long Character | CLOB | Cref ID by URL |
| 14 | MENUNAME_STRING | Character(50) | VARCHAR2(50) NOT NULL | Used on a transfer panelgroup call |
| 15 | COMPONENT_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Publication Title |
| 16 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |