CAP

(SQL Table)
 Index Back

Capital Acquisition Plan

  • Related Language Record: CAP_LANG

  • Parent Record Of CAP_ANNUAL_COST CAP_AUTHORIZE CAP_DET CAP_DET_LANG CAP_JUSTIFY

    • # 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 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CAP_CLASS Character(3) VARCHAR2(3) NOT NULL Capital Acquisition Plan Class
    COS=Cost Reduction
    EXP=Expansion
    NEC=Necessity
    NEW=New

    Default Value: NEW

    5 BD_UPDATE_FLAG Character(1) VARCHAR2(1) NOT NULL Update Flag
    N=No
    Y=Yes