EM_BANK_DSCR_V2 (SQL View)	Index Back
Bank Code Description View of the BANK_CD_TBL to retrieve the description and use it related-display on the EM_BUY_REG_BNK page.

EM_BANK_DSCR_V2

(SQL View)

Bank Code Description

View of the BANK_CD_TBL to retrieve the description and use it related-display on the EM_BUY_REG_BNK page.

SELECT A.SETID ,A.BANK_CD , A.DESCR FROM PS_BANK_CD_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description