BAL_CD_VW_LANG (SQL View)	Index Back
Bank Statement Code lang View Bank Statement Code language View. This is a language view over BALANCE_CODE_VW for types 1 and 2. 12/12/2005 cmh Removed TYPE_CODE field

BAL_CD_VW_LANG

(SQL View)

Bank Statement Code lang View

Bank Statement Code language View. This is a language view over BALANCE_CODE_VW for types 1 and 2. 12/12/2005 cmh Removed TYPE_CODE field

SELECT A.BANK_STMT_CODE , B.LANGUAGE_CD , B.DESCR50 , B.DESCR20A FROM PS_STMT_CODE_TBL A , PS_STMT_CODE_LANG B WHERE A.BANK_STMT_CODE = B.BANK_STMT_CODE AND A.TYPE_CODE IN ('1','2')

Related Language Record for BALANCE_CODE_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	DESCR20A	Character(20)	VARCHAR2(20) NOT NULL	Short Description