RB_TD_TDFN_LVW

(SQL View)
 Index Back

Transaction Definition View

Transaction Definition View that returns the description of the Action.

SELECT a.TRANSACTION_NAME , a.ACTION_DFN_ID , b.LANGUAGE_CD , b.DESCR FROM PS_RB_TD_TRANS_ACT a , PS_RB_TD_ACT_DRLR b WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID

  • Related Language Record for RB_TD_TDFN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

    Prompt Table: RB_TD_TRANS_HDR

    2 TRANS_DFN_ID Character(10) VARCHAR2(10) NOT NULL Transaction Type ID

    Prompt Table: RB_TD_ACT_DFN

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description