RE_LS_DS_RND_VW(SQL View) |
Index Back |
|---|
| SELECT LS_KEY , AMND_NBR , ASSET_SEQ_NBR , MAX(DISTRIBUTION_ID) FROM PS_RE_LSA_AST_DST GROUP BY LS_KEY , AMND_NBR , ASSET_SEQ_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | AMND_NBR | Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 3 | ASSET_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Asset Sequence Number |
| 4 | DISTRIBUTION_ID | Number(5,0) | INTEGER NOT NULL | Distribution ID |