RET_LIKE_EXC_VW(SQL View) |
Index Back |
---|---|
Retired Assets - Like Kind ExcView 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 |