CONVBOOK_LAN_VW

(SQL View)
 Index Back

Depreciation Prorate Convent'n


SELECT DISTINCT b.business_unit , C.setid , b.cal_depr_pd , a.convention , D.LANGUAGE_CD , D.descr FROM ps_CONV_TBL a , PS_BU_BOOK_VW b , ps_Set_Cntrl_Rec c , PS_CONV_LANG D WHERE A.setid = C.setid AND a.calendar_id = b.cal_depr_pd AND C.RECNAME = 'CONV_TBL' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.SETID = D.SETID AND A.CALENDAR_ID = D.CALENDAR_ID AND A.CONVENTION = D.CONVENTION

  • Related Language Record for CONV_BOOK_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar

    Default Value: CAL_DEFN_TBL.CALENDAR_ID

    4 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

    Default Value: CONV_TBL.CONVENTION

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description