RS_CALINE_VW

(SQL View)
 Index Back

PSA Junction View


SELECT LINE.CONTRACT_NUM , LINE.CONTRACT_LINE_NUM , HDR.BUSINESS_UNIT , LINE.PRODUCT_ID , LINE.PRODUCT_GROUP , LINE.PRICING_STRUCTURE , LINE.DESCR , HDR.SOLD_TO_CUST_ID FROM PS_CA_DETAIL LINE , PS_CA_CONTR_HDR HDR , PS_CA_DETAIL_VW1 VW WHERE LINE.CONTRACT_NUM = HDR.CONTRACT_NUM AND LINE.CONTRACT_NUM = VW.CONTRACT_NUM AND LINE.CONTRACT_LINE_NUM = VW.CONTRACT_LINE_NUM

  • Related Language Record: CA_DETAIL_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    6 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer