CA_BILL_PLAN_VW

(SQL View)
 Index Back

Contract Bill Plan

Primary record for each Contract Bill Plan.

SELECT CONTRACT_NUM ,BILL_PLAN_ID ,BILL_PLAN_TYPE ,DESCRSHORT ,DESCR ,BP_STATUS FROM PS_CA_BILL_PLAN WHERE BP_STATUS IN ('PND', 'RDY')

  • Related Language Record: CA_BILLPLN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: SP_CA_NONVW

    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

    Prompt Table: CA_BILL_PLAN

    3 BILL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Method
    01=As Incurred
    02=Installment
    03=Recurring
    04=Milestone
    05=Percent Complete
    06=Immediate
    07=Value Based
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
    CAN=Cancelled
    DON=Completed
    PND=Pending
    PRG=In Progress
    RCL=Recycled
    RDY=Ready
    RIP=Reversal In Progress
    RQD=Action Required
    RRP=Recycled
    RVS=Reversed