BNK_RCN_SD_VW

(SQL View)
 Index Back

Bank Recon Load View

Bank Recon Load View - Current Day

SELECT BNK_ID_NBR , BANK_ACCOUNT_NUM , STATEMENT_ID , ASOFDATE , CYCLE_STATUS , BNK_LOAD_DTTM FROM PS_BANK_STMT_HDR WHERE BNK_STMT_TYPE = '1' AND EXISTS ( SELECT 'X' FROM PS_BANK_SDSTMT_TBL WHERE BNK_ID_NBR = PS_BANK_STMT_HDR.BNK_ID_NBR AND BANK_ACCOUNT_NUM = PS_BANK_STMT_HDR.BANK_ACCOUNT_NUM AND RECON_CYCLE_NBR = PS_BANK_STMT_HDR.STATEMENT_ID)

# 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.

Prompt Table: BANK_ID_VW

2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

Prompt Table: BANK_ACCTNUM_VW

3 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.
4 ASOFDATE Date(10) DATE As of Date
5 CYCLE_STATUS Character(1) VARCHAR2(1) NOT NULL Cycle Status
C=Complete
E=Load Failed
F=Fatal Error
I=EDI Loaded
L=Loading
N=Ready
P=Selected
R=Ready
X=Reconciling
6 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.