SETIDJOURNAL_CLASSOI_JRNL_CLS_VW(SQL View) |
Index Back |
|---|---|
Closing JournalOTBI Closing Journal View |
| SELECT A.SETID , A.JOURNAL_CLASS , A.DESCR , A.BUDGETARY_ONLY FROM %Table(JRNL_CLASS_TBL) A UNION SELECT B.SETID , ' ' , '-' , '-' FROM %Table(SETID_TBL) B UNION SELECT ' ' , ' ' , '-' , '-' FROM %Table(INSTALLATION) C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | JOURNAL_CLASS |
Character(10) | VARCHAR2(10) NOT NULL | Journal Class |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BUDGETARY_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Budgetary Only |