RET_NON_LIKE_VW

(SQL View)
Index Back

Retired Assets - Non Like Kind

View for Non like Kind Property for Like Kind Exchanges

SELECT a.business_unit , a.asset_id , a.non_like_kind , a.from_cur , a.retirement_dt FROM PS_RETIREMENT a , ps_bus_unit_tbl_am b WHERE a.disposal_code = 'L' AND a.non_like_asset_id = ' ' AND a.retirement_dt IS NOT NULL AND a.non_like_kind <> 0 AND a.book = b.default_book AND a.business_unit = b.business_unit GROUP BY a.business_unit, a.asset_id, a.non_like_kind, 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 NON_LIKE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Non Like Kind Asset
3 NON_LIKE_KIND Signed Number(28,3) DECIMAL(26,3) NOT NULL FMV Non Like Kind Property
4 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
5 RETIREMENT_DT Date(10) DATE Projected Retirement Date