SP_BUS_AM_CLSVW

(SQL View)
 Index Back

AM Business Unit Options


SELECT c.oprclass , 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 , ps_sec_bu_cls c WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND a.business_unit = c.business_unit

  • Related Language Record: SP_BUSAMCLS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 LAST_ASSET_ID Number(12,0) DECIMAL(12) NOT NULL Last Asset ID Used
    6 CAP_BOOK Character(10) VARCHAR2(10) NOT NULL Book Used by CAP

    Prompt Table: SP_BOOK_NONVW

    7 LEASE_BOOK Character(10) VARCHAR2(10) NOT NULL Book used by Lease

    Prompt Table: SP_BOOK_NONVW

    8 DEFAULT_BOOK Character(10) VARCHAR2(10) NOT NULL Default Book

    Prompt Table: SP_BOOK_NONVW

    9 FEDERAL_BOOK Character(10) VARCHAR2(10) NOT NULL U.S. Tax Federal Book
    10 AMT_BOOK Character(10) VARCHAR2(10) NOT NULL Alternative Minimum Tax
    11 ACE_BOOK Character(10) VARCHAR2(10) NOT NULL Adjusted Current Earnings
    12 BOOKS_IN_SYNCH_SW Character(1) VARCHAR2(1) NOT NULL Keep all books in synch

    Y/N Table Edit

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

    Y/N Table Edit

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