CA_WC_REVTR_VW

(SQL View)
 Index Back

Revenue Transition View

Revenue Transition View

SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , HDR.DESCR , HDR.CA_STATUS , HDR.SOLD_TO_CUST_ID , CUST.NAME1 , HDR.CONTRACT_TYPE , HDR.CONTRACT_ROLE , HDR.REVENUE_PROFILE , HDR.CONTRACT_ADMIN , HDR.REGION_CD , HDR.REV_TRANS_IMP , HDR.REV_TRANS_STS , MIN(DTL.START_DT) , HDR.TOTAL_REV_ADJ , HDR.CURRENCY_CD FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL DTL , PS_BUS_UNIT_TBL_CA BU , PS_CUSTOMER CUST , PS_SET_CNTRL_GROUP GRP WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND BU.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND BU.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND BU.REV_CONVERG_COMP ='N' AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID AND HDR.CA_RQST_SRC NOT IN ('OND','INT') AND HDR.CONTRACT_NUM = DTL.CONTRACT_NUM GROUP BY HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , HDR.DESCR , HDR.CA_STATUS , HDR.SOLD_TO_CUST_ID , CUST.NAME1 , HDR.CONTRACT_TYPE , HDR.CONTRACT_ROLE , HDR.REVENUE_PROFILE , HDR.CONTRACT_ADMIN , HDR.REGION_CD , HDR.REV_TRANS_IMP , HDR.REV_TRANS_STS , HDR.TOTAL_REV_ADJ , HDR.CURRENCY_CD

  • Related Language Record: CA_WC_REVTR_LVW

    • # 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 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
    5 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
    8 CONTRACT_ROLE Character(15) VARCHAR2(15) NOT NULL Contract Role
    9 REVENUE_PROFILE Character(15) VARCHAR2(15) NOT NULL Contract Revenue Profile
    10 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.
    11 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
    12 REV_TRANS_IMP Character(1) VARCHAR2(1) NOT NULL Revenue Transition Impact
    1=Materially Impacted
    2=Not Materially Impacted
    3=Not Yet Determined
    4=Post Transition
    13 REV_TRANS_STS Character(1) VARCHAR2(1) NOT NULL Revenue Transition Status
    1=Not Initiated
    2=In Preliminary Review
    3=Review Complete
    4=Contract Updated
    5=Post Transition
    14 START_DT Date(10) DATE Start Date
    15 TOTAL_REV_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Revenue Adjustment
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code