RE_LS_PLP_SS_VW(SQL View) |
Index Back |
|---|
| SELECT A.LS_KEY , A.STLINE_KEY , A.STLINE_SCH_KEY , SUM(A.ACCR_DEFR_AMT) FROM PS_RE_LS_PLP_SH_VW A LEFT OUTER JOIN PS_RE_LS_DS_RND_VW B ON (B.LS_KEY = A.LS_KEY AND B.AMND_NBR = A.AMND_NBR AND A.ASSET_SEQ_NBR = B.ASSET_SEQ_NBR AND A.DISTRIBUTION_ID = B.DISTRIBUTION_ID) WHERE A.ROUNDING_APPLIED <> 'Y' AND (B.DISTRIBUTION_ID IS NOT NULL OR A.DISTRIBUTION_ID IS NULL) GROUP BY A.LS_KEY , A.STLINE_KEY , A.STLINE_SCH_KEY |
| # | 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 | STLINE_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Straightline Key - Number (15) |
| 3 | STLINE_SCH_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Straightline Schedule Key - Number (15) |
| 4 | ACCR_DEFR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accrual/ Deferral Amount |