AP_NAVIGATION(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AP_HOME_DEST | Character(1) | VARCHAR2(1) NOT NULL |
Destination
A=Administration Home B=Batch Process Home H=Payables Home I=Review Home P=Payment Home R=Report Home V=Voucher Home W=1099 Home |
| 2 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 3 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 4 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 5 | ITEMLABEL | Character(30) | VARCHAR2(30) NOT NULL | Menu Item Label |
| 6 | PNLITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Panel Item Name |
| 7 | GF_LABEL1 | Character(30) | VARCHAR2(30) NOT NULL | Govt Financials - use msggettest to get label value from message catalog. |
| 8 | ACTION_FLAG | Character(2) | VARCHAR2(2) NOT NULL | Action Flag |
| 9 | READONLY | Character(1) | VARCHAR2(1) NOT NULL | Read Only |