RE_LS_AM_PSS_VW(SQL View) |
Index Back |
|---|
| SELECT A.TXN_KEY , SUM(A.AMOUNT) , SUM(A.OBLIGATION_REDUCE) , SUM(A.INTEREST_AMOUNT) FROM PS_RE_LS_AM_PSH_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.TXN_KEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TXN_KEY | Number(30,0) | DECIMAL(30) NOT NULL | Transaction Key |
| 2 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 3 | OBLIGATION_REDUCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Obligation Reduction |
| 4 | INTEREST_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest Amount |