RET_NON_LIKE_VW(SQL View) |
Index Back |
---|---|
Retired Assets - Non Like KindView 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 |