CA_AP_MGT_EV_VW

(SQL View)
 Index Back

Revenue Management: Events


SELECT DISTINCT HDR.CONTRACT_NUM , AP.ACCT_PLAN_ID ,AP.DESCR , EVT.EVENT_NUM , HDR.CURRENCY_CD , HDR.BUSINESS_UNIT , CABU.BUSINESS_UNIT_GL , HDR.SOLD_TO_CUST_ID , AP.AP_STATUS , HDR.CA_RQST_SRC , AP.REV_RECOG_METHOD , AP.HOLD_FLAG , AP.HOLD_DATE , EVT.AP_EVENT_TYPE , EVT.AP_EVENT_STATUS , EVT.CA_PERCENTAGE , EVT.AMOUNT ,HDR.CONTRACT_NUM , DET.CA_FEE_TYPE FROM PS_CA_CONTR_HDR HDR , PS_BUS_UNIT_TBL_CA CABU , PS_CA_ACCTPLAN AP , PS_CA_AP_EVENT EVT , PS_CA_DETAIL DET WHERE HDR.BUSINESS_UNIT = CABU.BUSINESS_UNIT AND HDR.CONTRACT_NUM = AP.CONTRACT_NUM AND AP.CONTRACT_NUM = EVT.CONTRACT_NUM AND AP.ACCT_PLAN_ID = EVT.ACCT_PLAN_ID AND DET.CONTRACT_NUM = AP.CONTRACT_NUM AND DET.ACCT_PLAN_ID = AP.ACCT_PLAN_ID AND NOT EXISTS ( SELECT 'X' FROM PS_CA_STATUS_TBL STS , PS_SET_CNTRL_REC ST WHERE ST.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND ST.RECNAME = 'CA_STATUS_TBL' AND STS.SETID = ST.SETID AND STS.CA_STATUS = HDR.CA_STATUS AND STS.CA_PROC_STATUS = 'C')

  • Related Language Record: CA_AP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
    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_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    8 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    9 AP_STATUS Character(3) VARCHAR2(3) NOT NULL Rev Rec Plan Status
    CAN=Cancelled
    DON=Completed
    NEW=Pending
    PRG=In Progress
    RDY=Ready
    RIP=Reversal in Progress
    RQD=Action Required
    RVS=Reversed
    10 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
    11 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
    1=As Incurred
    2=Apportionment
    3=Percent Complete
    4=Milestone
    5=Billing Manages Revenue
    12 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Y/N Table Edit

    13 HOLD_DATE Date(10) DATE Put On Hold Date
    14 AP_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting Event Type
    01=Date
    02=Milestone
    15 AP_EVENT_STATUS Character(3) VARCHAR2(3) NOT NULL Event Status
    CAN=Cancelled
    DON=Completed
    HLD=Hold Event
    NEW=Pending
    PRG=In Progress
    RDY=Ready
    RIN=Reversal Initiated
    RIP=Reversal In Progress
    RVS=Reversed
    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