BANK_ACCT_INTRM (SQL Table)	Index Back
Pymnt Methods for Bank Account Pymnt Methods for Bank Account

BANK_ACCT_INTRM

(SQL Table)

Pymnt Methods for Bank Account

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

3 BANK_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.

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 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
Default Value: CHK
Prompt Table: BNK_RCN_MTHD_VW

6 INTRMED_SEQ_NO Number(3,0) SMALLINT NOT NULL A numeric value that sequentially identifiers the series of banks utilized for a given m

7 INTRMED_BANK_CD Character(5) VARCHAR2(5) NOT NULL The intermediary transit bank utilized for multibank settlements.
Prompt Table: %EDITTABLE3

8 INTRMED_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL The intermediary transit bank account utilized for multibank settlements.
Prompt Table: %EDITTABLE4

9 INTRMED_DFI_ID Character(15) VARCHAR2(15) NOT NULL The intermediary bank DFI identifier.

10 INTRMED_PYMNT_MSG Character(30) VARCHAR2(30) NOT NULL An internal work field that contains messaging associated with settlements subject to

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	BANK_CD_CPTY	Character(5)	VARCHAR2(5) NOT NULL	An internal key field convention that facilitates the system distinction between banks and counterparties.
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	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer Default Value: CHK Prompt Table: BNK_RCN_MTHD_VW
6	INTRMED_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	A numeric value that sequentially identifiers the series of banks utilized for a given m
7	INTRMED_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	The intermediary transit bank utilized for multibank settlements. Prompt Table: %EDITTABLE3
8	INTRMED_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	The intermediary transit bank account utilized for multibank settlements. Prompt Table: %EDITTABLE4
9	INTRMED_DFI_ID	Character(15)	VARCHAR2(15) NOT NULL	The intermediary bank DFI identifier.
10	INTRMED_PYMNT_MSG	Character(30)	VARCHAR2(30) NOT NULL	An internal work field that contains messaging associated with settlements subject to