RE_LS_INTSUM_VW(SQL View) |
Index Back |
---|---|
View with rounded Interest ExpView with rounded Lease Interest expense amounts |
SELECT A.TERM_SCHED_ID , A.SEQ_NUM , SUM(A.INTEREST_EXPENSE) , SUM(A.INTEREST_ACCRUAL) , SUM(A.AMORTIZATION_AMT) FROM PS_RE_LS_AM_INT_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.TERM_SCHED_ID, A.SEQ_NUM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TERM_SCHED_ID | Number(30,0) | DECIMAL(30) NOT NULL | Lease Term Schedule ID |
2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
3 | INTEREST_EXPENSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest Expense |
4 | INTEREST_ACCRUAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest calculated |
5 | AMORTIZATION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amortization Amount |