SP_BUS_AM_NONVW

(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

  • Related Language Record: SP_BUSAMNON_LVW

    • # 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