CA_BI_MGMT_VW2

(SQL View)
Index Back

Billing Management

Billing Management General View. The contract num is available twice because we need it as a non-key in CA_BI_MGMT_INQ_PNL.

SELECT DISTINCT A.CONTRACT_NUM , A.BILL_PLAN_ID ,A.DESCR , A.CURRENCY_CD , E.BUSINESS_UNIT , E.BUSINESS_UNIT_BI , E.BILL_TO_CUST_ID , E.CA_PROC_STATUS , A.BILL_PLAN_TYPE , A.BP_STATUS , E.CA_RQST_SRC , A.HOLD_FLAG , A.HOLD_DATE , A.BILL_THRU_DATE , A.CONTRACT_NUM , DET.CA_FEE_TYPE FROM PS_CA_BILL_PLAN A , PS_CA_CONTR_HDR E , PS_CA_DETAIL DET WHERE A.CONTRACT_NUM = E.CONTRACT_NUM AND A.CONTRACT_NUM = DET.CONTRACT_NUM (+) AND A.BILL_PLAN_ID = DET.BILL_PLAN_ID (+) AND E.CA_RQST_SRC <> 'OND' AND E.CA_PROC_STATUS <> 'C' AND NOT EXISTS ( SELECT 'X' FROM PS_CA_BI_MGMT_VW3 V3 WHERE V3.CONTRACT_NUM = A.CONTRACT_NUM AND V3.BILL_PLAN_ID = A.BILL_PLAN_ID AND V3.CURRENCY_CD = A.CURRENCY_CD)

  • Related Language Record: CA_BI_MGMT_LVW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    7 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    8 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
    A=Active
    C=Closed
    P=Pending
    9 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
    10 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
    11 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
    FED=Federal Reimbursable Agreement
    GEN=Generic Application
    GOV=Government
    INT=Internal
    OND=CRM Field Services On Demand
    STD=Standard
    12 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold
    13 HOLD_DATE Date(10) DATE Put On Hold Date
    14 BILL_THRU_DATE Date(10) DATE Billed Thru Date
    15 CONTRACT_NUM_CA Character(25) VARCHAR2(25) NOT NULL Contract Number
    16 CA_FEE_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Plus Fee Type
    01=None
    02=Fixed Fee
    03=Award Fee
    04=Incentive Fee
    05=Other Fee