RE_LS_INTSUM_VW

(SQL View)
Index Back

View with rounded Interest Exp

View 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