BANK_RCN_RL_VW

(SQL View)
 Index Back

Bank Recon Rule View

Bank Recon Rule View - This view will display all bank recon rules that are configured in the system.

SELECT A.SOURCE , A.RULE_TYPE , A.RULE_ID_RECON , A.RULE_NAME_ALIAS , A.DESCR100 , A.STATEMENTGROUP , A.STATEMENTFILTER , B.TRANSACTIONGROUP , B.TRANSACTIONFILTER , A.MATCHCRITERIA FROM ( SELECT X1.XLATLONGNAME AS SOURCE , X2.XLATLONGNAME AS RULE_TYPE , R.RULE_ID_RECON , R.RULE_NAME_ALIAS , R.DESCR100 , F.ASQL_STMT AS STATEMENTGROUP , F.FSQL_STMT AS STATEMENTFILTER , ' ' AS TRANSACTIONGROUP , ' ' AS TRANSACTIONFILTER , M.MSQL_STMT AS MATCHCRITERIA FROM PS_BANK_RECON_RULE R LEFT OUTER JOIN PSXLATITEM X1 ON X1.FIELDNAME = 'RECON_SOURCE' AND X1.FIELDVALUE = R.RECON_SOURCE LEFT OUTER JOIN PSXLATITEM X2 ON X2.FIELDNAME = 'RECON_RULE_TYPE' AND X2.FIELDVALUE = R.RECON_RULE_TYPE INNER JOIN PS_BANK_RECON_FSQL F ON R.RECON_SOURCE = F.RECON_SOURCE AND R.RULE_ID_RECON = F.RULE_ID_RECON INNER JOIN PS_BANK_RECON_MSQL M ON R.RECON_SOURCE = M.RECON_SOURCE AND R.RULE_ID_RECON = M.RULE_ID_RECON WHERE RECNAME = 'BNK_RCN_STMT_VW' ) A INNER JOIN ( SELECT X1.XLATLONGNAME AS SOURCE , X2.XLATLONGNAME AS RULE_TYPE , R.RULE_ID_RECON , R.RULE_NAME_ALIAS , R.DESCR100 , ' ' AS STATEMENTGROUP , ' ' AS STATEMENTFILTER , F.ASQL_STMT AS TRANSACTIONGROUP , F.FSQL_STMT AS TRANSACTIONFILTER , M.MSQL_STMT AS MATCHCRITERIA FROM PS_BANK_RECON_RULE R LEFT OUTER JOIN PSXLATITEM X1 ON X1.FIELDNAME = 'RECON_SOURCE' AND X1.FIELDVALUE = R.RECON_SOURCE LEFT OUTER JOIN PSXLATITEM X2 ON X2.FIELDNAME = 'RECON_RULE_TYPE' AND X2.FIELDVALUE = R.RECON_RULE_TYPE INNER JOIN PS_BANK_RECON_FSQL F ON R.RECON_SOURCE = F.RECON_SOURCE AND R.RULE_ID_RECON = F.RULE_ID_RECON INNER JOIN PS_BANK_RECON_MSQL M ON R.RECON_SOURCE = M.RECON_SOURCE AND R.RULE_ID_RECON = M.RULE_ID_RECON WHERE RECNAME <> 'BNK_RCN_STMT_VW' ) B ON A.SOURCE = B.SOURCE AND A.RULE_TYPE = B.RULE_TYPE AND A.RULE_ID_RECON = B.RULE_ID_RECON

# 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 RECON_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Reconciliation Type
3 RULE_ID_RECON Character(20) VARCHAR2(20) NOT NULL Reconciliation Rules Id
4 RULE_NAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation Rule Alias
5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
6 ASQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.
7 FSQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.
8 ASQL_TRAN Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.
9 FSQL_TRAN Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.
10 MSQL_STMT Long Character(8192) CLOB Match Criteria