LINE_NBREX_TAULN_EXC_VW(SQL View) |
Index Back |
|---|---|
Travel Auth Exceptions ViewTravel Auth Exceptions View |
| SELECT TRAVEL_AUTH_ID ,LINE_NBR ,EXPENSE_TYPE ,EE_LOCAMT_COMMENT ,EE_PRFMRC_COMMENT FROM PS_EX_TAUTH_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRAVEL_AUTH_ID | Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 4 | EE_LOCAMT_COMMENT | Character(60) | VARCHAR2(60) NOT NULL | Location Amount Comment |
| 5 | EE_PRFMRC_COMMENT | Character(60) | VARCHAR2(60) NOT NULL | Preferred Vendor Comment |