SP_BK_RET_NONVW

(SQL View)
 Index Back

BU BOOK RETIRE FDA


SELECT BUSINESS_UNIT ,BOOK ,ALLOW_AUTO_RET_SW FROM PS_BU_BOOK_TBL WHERE ALLOW_AUTO_RET_SW = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 ALLOW_AUTO_RET_SW Character(1) VARCHAR2(1) NOT NULL Auto-Retire Fully Depr Assets
N=No
Y=Yes