BNK_INT_ACCT (SQL View)	Index Back
Internal Accounts Info 7/6/98 AK - Created. Show all the accounts Add the following where clause to restrict to internal accts where BANK_CD <> BANK_CD_CPTY

BNK_INT_ACCT

(SQL View)

Internal Accounts Info

7/6/98 AK - Created. Show all the accounts Add the following where clause to restrict to internal accts where BANK_CD <> BANK_CD_CPTY

select SETID,COUNTERPARTY, BANK_CD_CUST, BANK_ACCT_KEY, BANK_ACCOUNT_NUM from PS_BANK_ACCT_CPTY where BANK_CD <> BANK_CD_CPTY

# 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 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_INT_VW

3 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
Prompt Table: BANK_CD_INT_VW

4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

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

#	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	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_INT_VW
3	BANK_CD_CUST	Character(5)	VARCHAR2(5) NOT NULL	Represents the customer bank or counterparty in a relationship that pairs differing sets of b Prompt Table: BANK_CD_INT_VW
4	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.