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

TR_BAL_TOGRPH_V

(SQL View)

Balance to Graph

This view picks a balance to graph

SELECT %Substring(DESCR50, 1, 25) , BANK_STMT_CODE , PICK_BALANCE FROM PS_STMT_CODE_TBL WHERE BANK_STMT_CODE IN ( '010', '015','045')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BALFWD_TXT Character(25) VARCHAR2(25) NOT NULL Balance Forward text

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	BALFWD_TXT	Character(25)	VARCHAR2(25) NOT NULL	Balance Forward text
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