TR_WR_ACCT_E_VW (SQL View)	Index Back
Ext Bank Acct View for Inquiry View over External Bank Accounts with a Payment Method in ('ACH','DD','EFT','WIR')

TR_WR_ACCT_E_VW

(SQL View)

Ext Bank Acct View for Inquiry

View over External Bank Accounts with a Payment Method in ('ACH','DD','EFT','WIR')

SELECT DISTINCT A.SETID ,A.BNK_ID_NBR ,B.BANK_ACCOUNT_NUM ,B.CASH_CNTL_USE_FLG ,B.DESCR FROM PS_BANK_CD_TBL A ,PS_BANK_ACCT_DEFN B ,PS_BANK_ACCT_MTHD C WHERE A.BANK_TYPE='E' AND B.ACCT_STATUS='A' AND B.SETID=A.SETID AND B.BANK_CD=A.BANK_CD AND C.SETID=B.SETID AND C.BANK_CD=B.BANK_CD AND C.BANK_CD_CPTY=B.BANK_CD_CPTY AND C.BANK_ACCT_KEY=B.BANK_ACCT_KEY AND C.PYMNT_METHOD IN ('ACH','DD','EFT','WIR')

Related Language Record: TR_WR_AC_E_V_L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

3 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

4 CASH_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Cash Clearing
Y/N Table Edit
Default Value: N

5 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	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
3	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
4	CASH_CNTL_USE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Clearing Y/N Table Edit Default Value: N
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description