BUSINESS_UNITASSET_IDBOOKBOOK_CUR_VW2(SQL View) |
Index Back |
|---|---|
Current Financial Book - UOP |
| SELECT BUSINESS_UNIT, ASSET_ID, BOOK, UOP_ID, Group_Asset_Id From PS_BOOK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 4 | UOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Units of Production ID |
| 5 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Group Asset ID |