CA_DETAIL_VW

(SQL View)
 Index Back

Contract Lines


SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , CD.CONTRACT_LINE_NUM , CD.PRODUCT_ID , CD.DESCR , CD.PRICING_STRUCTURE FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL CD WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM

  • Related Language Record: CA_DETAIL_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_CA_NONVW

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

    Prompt Table: CA_DETAIL

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring