BANK_BAL_TOGRPH (SQL View)	Index Back
Balance to Graph This view picks a balance to graph

BANK_BAL_TOGRPH

(SQL View)

Balance to Graph

This view picks a balance to graph

SELECT DESCR20A , BANK_STMT_CODE , PICK_BALANCE FROM PS_STMT_CODE_TBL WHERE PICK_BALANCE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DESCR20A	Character(20)	VARCHAR2(20) NOT NULL	Short Description
2	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.
3	PICK_BALANCE	Character(1)	VARCHAR2(1) NOT NULL	Default Display