CA_LN_REDCTS_VW

(SQL View)
 Index Back

Contracts Line Reductions

As part of Revenue Recognition Project, this record fetches data from the new revenue discounts table.

SELECT A.BUSINESS_UNIT ,B.CONTRACT_NUM ,B.CONTRACT_LINE_NUM ,B.SEQ_NUM ,B.DISC_SUR_ID ,B.DISC_SUR_INDICATOR ,B.DESCR ,B.PERCENTAGE ,B.AMOUNT ,B.ALLOC_REDUCT_FLG ,B.CURRENCY_CD FROM PS_CA_CONTR_HDR A , PS_CA_LNREV_REDUCT B WHERE A.CONTRACT_NUM = B.CONTRACT_NUM

  • Related Language Record: CA_LNRED_VW_LNG

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

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

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

    Prompt Table: SP_CA_NONVW

    3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    5 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

    Prompt Table: CA_DISC_SUR_VW3

    6 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
    D=Discount
    I=Installment Surcharge
    S=Surcharge

    Default Value: D

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    10 ALLOC_REDUCT_FLG Character(1) VARCHAR2(1) NOT NULL Allocated Reduction

    Y/N Table Edit

    Default Value: N

    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CA_CONTR_HDR.CURRENCY_CD