AP_SRC_TRAN_LVW

(SQL View)
 Index Back

AP Source Transactions

AP Source Transactions

SELECT T.KK_SOURCE_TRAN , T.LANGUAGE_CD , T.DESCR FROM PS_KK_SOURCE_TRAN T1 , PS_KK_SRC_TRN_LANG T WHERE T1.KK_SOURCE_TRAN = T.KK_SOURCE_TRAN AND T1.RECNAME_LINE IN ('VCHR_ACT_LN_VW', 'DIST_LINE_NP_VW', 'DISTRIB_LINE', 'VCHR_ACT_LN3_VW', 'VCHR_ACT_LN4_VW','VCHR_ACT_LN5_VW','VCHR_ACT_LN6_VW' )

  • Related Language Record for AP_SRC_TRAN_VW

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