BI_IB_SUR_LN_VW

(SQL View)
 Index Back

Line Search vw of Install Sur


SELECT DS.SETID , DS.BI_CURRENCY_CD , DS.DISC_SUR_ID , DS.DESCR , DS.AMOUNT , DS.PERCENTAGE , DS.DST_ID , DS.CALCULATION_CD FROM PS_BI_DISC_SUR DS WHERE DS.DISC_SUR_INDICATOR = 'I' AND DS.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BI_DISC_SUR WHERE SETID=DS.SETID AND DISC_SUR_ID =DS.DISC_SUR_ID AND BI_CURRENCY_CD = DS.BI_CURRENCY_CD AND EFFDT <= %CurrentDateIn AND EFF_STATUS='A')

  • Related Language Record: BI_IBSUR_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

    Prompt Table: CURRENCY_CD_TBL

    3 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    6 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    7 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
    8 CALCULATION_CD Character(3) VARCHAR2(3) NOT NULL Calculation_cd
    AMT=Amount
    PCT=Percentage