AVPLEDGEVWLNG

(SQL View)
 Index Back

Pledge Detail VW

Exact view of AV_PLEDGE_DTL with no peoplecode 7.27.00 SELECT INSTITUTION, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, GIFT_AMT, CURRENCY_CD, PLDG_EFFDT, PLEDGE_DT, FULF_DT, PMT_SCHD, DATA_ENTRY_DT, PLEDGE_PMT_RCVD, LAST_PMT_DT, SEQ_NO, ADJUSTMENT_FLG, CP_PLEDGE_NO, FISCAL_YEAR, FEED_FLG, PMT_DTL_CHG, AV_PLDG_STATUS, PLEDGE_PG_TYPE, ACKN_FLG, DESCRLONG FROM PS_AV_PLEDGE_DTL

SELECT BUSINESS_UNIT , SESSION_NO , GIFT_NO , LANGUAGE_CD , DESCRLONG FROM PS_AVPLEDGEDTLLNG

  • Related Language Record for AV_PLEDGE_VW

  • Parent record: AV_SESSION_TBL

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

    Prompt Table: AV_INST_BU_VW

    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Default Value: NEW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB Long Description