BUS_UNIT_AM_VW

(SQL View)
 Index Back

AM Business Unit Options


SELECT A.BUSINESS_UNIT, B.DESCR, B.DESCRSHORT, A.LAST_ASSET_ID, A.CAP_BOOK, A.LEASE_BOOK, A.DEFAULT_BOOK, A.FEDERAL_BOOK, A.AMT_BOOK, A.ACE_BOOK, A.BOOKS_IN_SYNCH_SW, A.ALLOW_DUP_TAGS_SW, A.DEFAULT_TAG_SW, A.IN_USE_SW, A.JV_UNIT_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.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 FEDERAL_BOOK Character(10) VARCHAR2(10) NOT NULL U.S. Tax Federal Book
9 AMT_BOOK Character(10) VARCHAR2(10) NOT NULL Alternative Minimum Tax
10 ACE_BOOK Character(10) VARCHAR2(10) NOT NULL Adjusted Current Earnings
11 BOOKS_IN_SYNCH_SW Character(1) VARCHAR2(1) NOT NULL Keep all books in synch

Y/N Table Edit

12 ALLOW_DUP_TAGS_SW Character(1) VARCHAR2(1) NOT NULL Allow duplicate tag numbers

Y/N Table Edit

13 DEFAULT_TAG_SW Character(1) VARCHAR2(1) NOT NULL Default tag # from asset ID
14 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch
15 JV_UNIT_SW Character(1) VARCHAR2(1) NOT NULL Joint Venture Unit