RCN_EVENT_VW_LG

(SQL View)
 Index Back

Reconciliatiton Event view

Reconciliation Event view for prompting

SELECT A.RCN_SOURCE_NAME , A.RCN_EVENT_SEQ , R.LANGUAGE_CD , R.DESCR FROM PS_RCN_EVENT_HDR A , PS_RCN_EVENT_H_LNG R WHERE A.RCN_SOURCE_NAME = R.RCN_SOURCE_NAME AND A.RCN_EVENT_SEQ = R.RCN_EVENT_SEQ

  • Related Language Record for RCN_EVENT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RCN_SOURCE_NAME Character(20) VARCHAR2(20) NOT NULL This field contains the reconciliation source that reconcile with a bank statement line
    2 RCN_EVENT_SEQ Number(4,0) SMALLINT NOT NULL Event Sequence Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description