GP_BNK_CD_VW1 (SQL View)	Index Back
Prompt VW Bank Code Used in Add Mode search record for Bank File Entry Component

GP_BNK_CD_VW1

(SQL View)

Prompt VW Bank Code

Used in Add Mode search record for Bank File Entry Component

SELECT DISTINCT A.SRC_BANK_ID , A.BANK_CD , A.ACCOUNT_NAME FROM PS_SRC_BANK A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

2 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

3 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
2	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
3	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name