CA_BP_TMPL_VW

(SQL View)
 Index Back

Bill Plan Templates

Bill Plan Templates View

SELECT SETID , PLAN_TMPL_ID , PLAN_METHOD , DESCR FROM PS_CA_PLAN_TMPL WHERE PLAN_METHOD IN ('1','3','4','6','7','8')

  • Related Language Record: CA_BP_TMP_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CA_BP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Template
    3 PLAN_METHOD Character(2) VARCHAR2(2) NOT NULL Plan Method
    1=As Incurred
    2=Apportionment
    3=Percent Complete
    4=Milestone
    6=Immediate
    7=Value Based
    8=Recurring
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description