BNK_RCN_DTL_VW2

(SQL View)
Index Back

Bank Recon Detail Prompt View


SELECT A.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM ,A.RECON_CYCLE_NBR ,B.PYMNT_ID_REF FROM PS_BANK_STMT_TBL A , PS_BNK_RCN_DISBRSE B WHERE A.BNK_ID_NBR=B.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM=B.BANK_ACCOUNT_NUM AND A.RECON_REF_ID=B.PYMNT_ID_REF AND B.RECON_TYPE IN ('U','V') AND A.RECON_STATUS NOT IN ('DPI','NTF','NUL','REC')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
3 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

Prompt Table: BNK_RCN_CYC

4 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference