BUSINESS_UNITBOOKBU_BOOK_MC_VW(SQL View) |
Index Back |
|---|---|
Business Unit Financial Books |
| SELECT a.Business_Unit , a.Book FROM PS_BU_BOOK_TBL a , ps_Book_Defn_Tbl b WHERE b.SetID = ( SELECT SetID FROM ps_Set_Cntrl_Rec c WHERE c.SetCntrlValue= a.Business_Unit AND c.RecName='BOOK_DEFN_TBL') AND a.Book = b.Book |
| # | 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 |