RB_TD_TRANS_VW

(SQL View)
 Index Back

View on Transactions

This is a view on RB_TD_TRANS_DFN and RB_TD_TRANS_DTL. This view has been created to optimize the call to the database in the application class/method RB_TD_360:TreeConfiguration. GetTransaction().

SELECT a.TRANSACTION_NAME , a.ACTION_DFN_ID , b.DESCR , a.STATUS FROM PS_RB_TD_TRANS_ACT a , PS_RB_TD_ACT_DFN b WHERE a.ACTION_DFN_ID = b.ACTION_DFN_ID

  • Related Language Record: RB_TD_TRANS_RVW

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

    Prompt Table: RB_TD_ACT_DFN

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A