SHEET_IDEX_MAX_LN_DL_VW(SQL View) |
Index Back |
|---|---|
Max Line and Dist Line ViewMax Line Number and Max Distrib Line Number View |
| SELECT SHEET_ID , MAX(LINE_NBR) , MAX(DISTRIB_LINE_NUM) FROM PS_EX_SHEET_DIST GROUP BY SHEET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | MAX_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Maximum Line Number |
| 3 | MAX_DISTRIB_LINE | Number(5,0) | INTEGER NOT NULL | Highest Distribution Line |