BNK_STMT_PRSE_V (SQL View)	Index Back
Bank Statement Addenda Parsing Bank Statement Addenda Parsing View - Previous Day Statements

BNK_STMT_PRSE_V

(SQL View)

Bank Statement Addenda Parsing

Bank Statement Addenda Parsing View - Previous Day Statements

SELECT BNK_ID_NBR , BANK_ACCOUNT_NUM , RECON_CYCLE_NBR , RECORD_SEQ_NUMBER , RECON_REF_ID , RECON_TRANS_CODE , STMT_ACTIVITY_TYPE , BANK_STMT_CODE , DESCRLONG FROM PS_BANK_STMT_TBL WHERE RECON_STATUS IN ('UNR', 'NTF')

Parent record: BANK_STMT_HDR

# 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 RECORD_SEQ_NUMBER Number(10,0) DECIMAL(10) NOT NULL An internal work field utilized to enumerate database records in bank statement processing.

5 RECON_REF_ID Character(20) VARCHAR2(20) NOT NULL The transaction reference identifier on the inbound bank statement.

6 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House
B=Direct Debit
BA=Bank Adjustments
BOE=Bill of Exchange - Disburse
BOO=Bill of Order - Disburse
C=Trade Receipt
CHK=Check
D=Deposits
DD=Direct Debit - Disburse
EFT=Electronic Funds Transfer
F=Fee Expense
G=General Transaction
I=Interest Expense
M=Miscellaneous Transaction
MAN=Manual Check
P=Payment
R=Drafts
S=Stop Pay
TRW=Treasury Wire
U=Funding Receipt
V=Voided Payment
WIR=Wire - Disbursement
WRI=Wire - Incoming

7 STMT_ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Represents a series of values that provide a more granular definition of a given reconcil
Prompt Table: BANK_ACT_TYPE

8 BANK_STMT_CODE Character(8) VARCHAR2(8) NOT NULL Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.
Prompt Table: BSP_TXN_CODE_VW

9 DESCRLONG Long Character CLOB Long Description

#	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	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
5	RECON_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	The transaction reference identifier on the inbound bank statement.
6	RECON_TRANS_CODE	Character(3)	VARCHAR2(3) NOT NULL	The PeopleSoft-specific bank transaction code ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming
7	STMT_ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Represents a series of values that provide a more granular definition of a given reconcil Prompt Table: BANK_ACT_TYPE
8	BANK_STMT_CODE	Character(8)	VARCHAR2(8) NOT NULL	Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions. Prompt Table: BSP_TXN_CODE_VW
9	DESCRLONG	Long Character	CLOB	Long Description