BANK_STMT_VW (SQL View)	Index Back
Bank Recon Statement View

BANK_STMT_VW

(SQL View)

Bank Recon Statement View

SELECT BNK_ID_NBR , BANK_ACCOUNT_NUM , STATEMENT_ID , ASOFDATE , CYCLE_STATUS FROM PS_BANK_STMT_HDR WHERE BNK_STMT_TYPE = '2' AND EXISTS ( SELECT 'X' FROM PS_BANK_STMT_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.

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.

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

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