CA_DETL_PRC_VW

(SQL View)
 Index Back

SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , CURRENCY_CD , PRODUCT_ID , DESCR , BUNDLE_OFFERING , GROSS_AMT , CA_LINE_STATUS , LIST_PRICE , NET_AMOUNT , PERCENTAGE , PRICING_STRUCTURE , QTY , RENEWABLE , UNIT_OF_MEASURE FROM PS_CA_DETAIL WHERE PRICING_STRUCTURE = 'AMT' AND CA_LINE_STATUS IN ('A','R')

  • Related Language Record: CA_DTL_PRICE_LG

    • # 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 APPLIES_TO_LINE Number(3,0) SMALLINT NOT NULL PSIRS-KK
    3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: BUS_UNIT_TBL_CA

    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 BUNDLE_OFFERING Character(20) VARCHAR2(20) NOT NULL Bundle
    7 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
    8 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
    A=Active
    C=Cancelled
    P=Pending
    R=Renewed
    9 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    10 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
    11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    12 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    13 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    14 RENEWABLE Character(1) VARCHAR2(1) NOT NULL Renewable
    15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL