CA_BI_MGT_EV_VW

(SQL View)
 Index Back

Billing Management Milest. Vw


SELECT DISTINCT HDR.CONTRACT_NUM , BP.BILL_PLAN_ID ,BP.DESCR , EVT.EVENT_OCCURRENCE , HDR.CURRENCY_CD , HDR.BUSINESS_UNIT , BP.BUSINESS_UNIT_BI , BP.BILL_TO_CUST_ID , BP.BP_STATUS , BP.BILL_PLAN_TYPE , BP.HOLD_FLAG , BP.HOLD_DATE , EVT.BILL_EVENT_TYPE , EVT.BP_EVENT_STATUS , HDR.CA_RQST_SRC , EVT.CA_PERCENTAGE , EVT.AMOUNT , HDR.CONTRACT_NUM , DET.CA_FEE_TYPE FROM PS_CA_CONTR_HDR HDR , PS_CA_BILL_PLAN BP , PS_CA_DETAIL DET , PS_CA_BP_EVENTS EVT WHERE HDR.CONTRACT_NUM = BP.CONTRACT_NUM AND BP.CONTRACT_NUM = DET.CONTRACT_NUM (+) AND BP.BILL_PLAN_ID = DET.BILL_PLAN_ID (+) AND BP.CONTRACT_NUM = EVT.CONTRACT_NUM AND BP.BILL_PLAN_ID = EVT.BILL_PLAN_ID AND HDR.CA_PROC_STATUS <> 'C'

  • 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 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    7 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    8 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    9 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
    10 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
    11 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Y/N Table Edit

    12 HOLD_DATE Date(10) DATE Put On Hold Date
    13 BILL_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Event Types -- Date or Milestone
    01=Date
    02=Milestone
    14 BP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
    CAN=Cancelled
    DON=Completed
    HLD=Hold Event
    NEW=New Event
    PND=Pending
    PRG=In Progress
    RCL=Recycled
    RDY=Ready
    REC=Recycled
    RIN=Reversal Initiated
    RIP=Reversal In Progress
    RRP=Recycled
    RVS=Reversed
    15 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
    16 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage
    17 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    18 CONTRACT_NUM_CA Character(25) VARCHAR2(25) NOT NULL Contract Number
    19 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