CA_DTL_RATE_VW

(SQL View)
 Index Back

CA_DETAILS with RATE Price Str


SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , DESCR FROM PS_CA_DETAIL WHERE PRICING_STRUCTURE = 'RATE' AND CA_LINE_STATUS <> 'C' AND CHG_STATUS <> 'X'

  • 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

    Prompt Table: CA_CONTR_HDR

    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description