CA_BP_EVT_VW

(SQL View)
 Index Back

Contracts Bill Plan View

Contracts Bill Plan Status View- Used in Pivot Grid

SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , HDR.DESCR , BP.BILL_PLAN_ID , BP.DESCR , EVT.EVENT_OCCURRENCE , EVT.BP_EVENT_STATUS , EVT.EVENT_DT , EVT.AMOUNT , EVT.CURRENCY_CD FROM PS_CA_CONTR_HDR HDR , PS_CA_BILL_PLAN BP , PS_CA_BP_EVENTS EVT WHERE HDR.CONTRACT_NUM = BP.CONTRACT_NUM AND BP.BILL_PLAN_ID = EVT.BILL_PLAN_ID AND BP.CONTRACT_NUM = EVT.CONTRACT_NUM UNION SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , HDR.DESCR , BP.BILL_PLAN_ID , BP.DESCR , EVT.EVENT_OCCURRENCE , EVT.BP_EVENT_STATUS , EVT.EVENT_DT , EVT.AMOUNT , EVT.CURRENCY_CD FROM PS_CA_CONTR_HDR HDR , PS_CA_BILL_PLAN BP , PS_CA_BP_EVT_CHG EVT WHERE HDR.CONTRACT_NUM = BP.CONTRACT_NUM AND BP.CONTRACT_NUM = EVT.CONTRACT_NUM AND BP.BILL_PLAN_ID = EVT.BILL_PLAN_ID

  • Related Language Record: CA_BPEVT_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 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.
    7 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
    8 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
    9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code