RE_AM_LO_SUM_VW

(SQL View)
 Index Back

Lease Chart Temp View


SELECT Business_Unit , Asset_ID , LEASE_BOOK , SUM( CASE WHEN FIRST_PYMNT_SW='Y' THEN ((INTEREST_EXPENSE) * (-1)) ELSE CASE WHEN ASSET_CLASSIFY='C' THEN (OBLIGATION_REDUCE - INTEREST_EXPENSE) ELSE OBLIGATION_REDUCE END END) ,SUM( CASE WHEN FIRST_PYMNT_SW='Y' THEN %DecMult(LO_INTRST_AMT_BSE,-1) ELSE CASE WHEN ASSET_CLASSIFY='C' THEN (OBLG_REDUCE_BSE - LO_INTRST_AMT_BSE) ELSE OBLG_REDUCE_BSE END END) FROM PS_RE_AM_CHART1_VW WHERE LEASE_TYPE = 'Y' AND TERM_RENT_TYPE NOT IN ('04', '09', '10') GROUP BY Business_Unit , Asset_ID , LEASE_BOOK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 LEASE_BOOK Character(10) VARCHAR2(10) NOT NULL Book used by Lease
4 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
5 OBLG_REDUCE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction