BNK_CD_VNDR_VW (SQL View)	Index Back
Supplier Banks/Counterparties Prompting view that shows only those Supplier bank codes that have accounts defined. Used on records where bank code/account are entered in combination.

BNK_CD_VNDR_VW

(SQL View)

Supplier Banks/Counterparties

Prompting view that shows only those Supplier bank codes that have accounts defined. Used on records where bank code/account are entered in combination.

SELECT DISTINCT v.setid , v.vendor_id , v.vndr_loc , v.bank_acct_seq_nbr , v.descr , v.beneficiary_bank FROM PS_VNDR_BANK_ACCT v WHERE effdt = ( SELECT MAX(effdt) FROM PS_VNDR_BANK_ACCT WHERE setid = v.setid AND vendor_id = v.vendor_id AND vndr_loc = v.vndr_loc AND bank_acct_seq_nbr = v.bank_acct_seq_nbr)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

4 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

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

6 BANK_NAME Character(30) VARCHAR2(30) NOT NULL Bank Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	BANK_NAME	Character(30)	VARCHAR2(30) NOT NULL	Bank Name