BUS_UNIT_AM_VW2(SQL View) |
Index Back |
|---|---|
AM Bus Unit Options for IU trf |
| SELECT A.BUSINESS_UNIT , B.DESCR , B.DESCRSHORT , A.LAST_ASSET_ID , A.CAP_BOOK , A.LEASE_BOOK , A.DEFAULT_BOOK , A.BOOKS_IN_SYNCH_SW , A.ALLOW_DUP_TAGS_SW FROM PS_BUS_UNIT_TBL_AM A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NEW_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
New Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | LAST_ASSET_ID | Number(12,0) | DECIMAL(12) NOT NULL | Last Asset ID Used |
| 5 | CAP_BOOK | Character(10) | VARCHAR2(10) NOT NULL |
Book Used by CAP
Prompt Table: SP_BOOK_NONVW |
| 6 | LEASE_BOOK | Character(10) | VARCHAR2(10) NOT NULL |
Book used by Lease
Prompt Table: SP_BOOK_NONVW |
| 7 | DEFAULT_BOOK | Character(10) | VARCHAR2(10) NOT NULL |
Default Book
Prompt Table: SP_BOOK_NONVW |
| 8 | BOOKS_IN_SYNCH_SW | Character(1) | VARCHAR2(1) NOT NULL |
Keep all books in synch
Y/N Table Edit |
| 9 | ALLOW_DUP_TAGS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow duplicate tag numbers
Y/N Table Edit |