KK_SRC_TRAN_VW2

(SQL View)
 Index Back

Tran Type (All) Prompt View

Prompt View of all Source Transaction Types. Used by Budget checking results search view.

SELECT DISTINCT A.KK_SOURCE_TRAN ,B.DESCR FROM PS_KK_SOURCE_HDR A ,PS_KK_SOURCE_TRAN B WHERE A.KK_SOURCE_TRAN = B.KK_SOURCE_TRAN

  • Related Language Record: KK_SRC_TRN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description