RET_LIKE_EXC_VW

(SQL View)
Index Back

Retired Assets - Like Kind Exc

View Like Kind asset for Like Kind Exchanges

SELECT a.business_unit , a.asset_id , SUM(a.proceeds) , a.from_cur , a.retirement_dt FROM PS_RETIREMENT a , ps_bus_unit_tbl_am b WHERE a.disposal_code = 'L' AND a.like_exch_asset_id = ' ' AND a.retirement_dt IS NOT NULL AND a.book = b.default_book AND a.business_unit = b.business_unit AND a.groupid_one_many = ' ' GROUP BY a.business_unit, a.asset_id, a.from_cur, a.retirement_dt HAVING SUM(a.trade_in_value) <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LIKE_EXCH_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Like Exch Asset
3 PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Proceeds
4 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
5 RETIREMENT_DT Date(10) DATE Projected Retirement Date