BU_BOOK_GRP_VW

(SQL View)
 Index Back

Bus. Unit Books w/Dist=Y & Inf


SELECT a.BUSINESS_UNIT , a.BOOK , b.DESCR , a.BOOK_TYPE , a.DISTRIBUTION_SW , a.DISPOSAL_DIST_SW , a.BUSINESS_UNIT_GL , a.CAL_DEPR_PD FROM PS_BU_BOOK_TBL a , PS_BOOK_DEFN_TBL b WHERE b.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC c WHERE c.SETCNTRLVALUE= a.BUSINESS_UNIT AND c.RECNAME='BOOK_DEFN_TBL') AND a.BOOK = b.BOOK AND a.group_proc_sw = 'Y'

  • Related Language Record: BUBK_GRP_LN_VW

  • Parent record: BUS_UNIT_TBL_AM

    • # 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 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

    Prompt Table: SP_BOOK_NONVW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BOOK_TYPE Character(1) VARCHAR2(1) NOT NULL Depreciation Book Type
    A=U.S. AMT Book
    F=Corporate Book
    P=Corporate w/Tax Info
    T=Main Tax Book

    Default Value: F

    5 DISTRIBUTION_SW Character(1) VARCHAR2(1) NOT NULL Distribution Switch
    N=No
    Y=Yes

    Default Value: N

    6 DISPOSAL_DIST_SW Character(1) VARCHAR2(1) NOT NULL Distribute by Disposal Code

    Y/N Table Edit

    Default Value: N

    7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    8 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar

    Prompt Table: CAL_DEFN_DPR_VW