GP_BNK_CUR_VW (SQL View)	Index Back
Prompt VW Currency code Used for Add Mode search record for Bank File Entry Component

GP_BNK_CUR_VW

(SQL View)

Prompt VW Currency code

Used for Add Mode search record for Bank File Entry Component

SELECT DISTINCT A.SRC_BANK_ID , A.CURRENCY_CD , D.DESCRSHORT , A.ACCOUNT_NAME FROM PS_SRC_BANK A , PS_BANK_EC_TBL B , PS_CURRENCY_CD_TBL D WHERE D.CURRENCY_CD = A.CURRENCY_CD AND A.BANK_CD = B.BANK_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 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	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name