BUSINESS_UNITLK_MULTI_ASSET_IDRET_LK_MULT_VW(SQL View) |
Index Back |
|---|---|
One to Many - Like KindExcView Like Kind asset for Like Kind Exchanges - One to Many |
| SELECT C.BUSINESS_UNIT , C.ASSET_ID , C.SERIAL_COUNT , C.BOOK , C.TRADE_IN_VALUE , A.TRADE_IN_VALUE , A.FROM_CUR , A.RETIREMENT_DT FROM PS_RETIREMENT A , PS_BUS_UNIT_TBL_AM B , PS_RET_DET_TBL C WHERE A.DISPOSAL_CODE = 'L' AND C.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.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BOOK = C.BOOK AND A.ASSET_ID = C.ASSET_ID AND A.DTTM_STAMP = C.DTTM_STAMP AND A.GROUPID_ONE_MANY <> ' ' AND C.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 | LK_MULTI_ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Like Exch One Many Asset |
| 3 | SERIAL_COUNT | Number(6,0) | INTEGER NOT NULL | Serial Count |
| 4 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 5 | TRADE_IN_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Trade In value |
| 6 | PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retirement Proceeds |
| 7 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 8 | RETIREMENT_DT | Date(10) | DATE | Projected Retirement Date |