BANK_RCN_OPT_VW

(SQL View)
 Index Back

Bank Recon Options

Bank Recon Options.

SELECT DISTINCT B.RCN_SOURCE_NAME ,B.RCN_OPTION_CODE FROM PS_RCN_EVENT_HDR A , PS_RCN_EVENT_TBL B WHERE B.RCN_SOURCE_NAME=A.RCN_SOURCE_NAME AND B.RCN_EVENT_SEQ=A.RCN_EVENT_SEQ AND A.ACTIVE_FLG='Y' AND B.RCN_CONDITION_FLAG='Y'

# 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_OPTION_CODE Character(5) VARCHAR2(5) NOT NULL Option Code

Prompt Table: RCN_USR_OPTIONS