BANK_STMT_SD_VW (SQL View)	Index Back
Bank Stmt Header for Previous

BANK_STMT_SD_VW

(SQL View)

Bank Stmt Header for Previous

SELECT DISTINCT bnk_id_nbr ,bank_account_num ,statement_id ,bnk_load_dttm FROM PS_BANK_STMT_HDR WHERE bnk_stmt_type = '1'

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

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

3 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

4 BNK_LOAD_DTTM DateTime(26) TIMESTAMP The time and date a bank statement is loaded into the system.

#	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_DVW
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account. Prompt Table: BNK_ACCTNUM_DVW
3	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
4	BNK_LOAD_DTTM	DateTime(26)	TIMESTAMP	The time and date a bank statement is loaded into the system.