RET_LK_MULT_VW1(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 |