BALANCE_CODE_VW (SQL View)	Index Back
Bank Statement Code View This is view over Bank Statement code table. (STMT_CODE_TBL) and picks only those rows that are of type 1 or 2.

BALANCE_CODE_VW

(SQL View)

Bank Statement Code View

This is view over Bank Statement code table. (STMT_CODE_TBL) and picks only those rows that are of type 1 or 2.

SELECT BANK_STMT_CODE , TYPE_CODE , PICK_BALANCE , DESCR50 , DESCR20A FROM PS_STMT_CODE_TBL WHERE TYPE_CODE IN ('1','2')

Related Language Record: BAL_CD_VW_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TYPE_CODE Character(1) VARCHAR2(1) NOT NULL Uniform Type Code
1=Account Status
2=Activity Summary
3=Transaction Detail

3 PICK_BALANCE Character(1) VARCHAR2(1) NOT NULL Default Display

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 DESCR20A Character(20) VARCHAR2(20) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	TYPE_CODE	Character(1)	VARCHAR2(1) NOT NULL	Uniform Type Code 1=Account Status 2=Activity Summary 3=Transaction Detail
3	PICK_BALANCE	Character(1)	VARCHAR2(1) NOT NULL	Default Display
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	DESCR20A	Character(20)	VARCHAR2(20) NOT NULL	Short Description