BANK_MTHD_VW (SQL View)	Index Back
Pymnt Methods using BANK_SETID

BANK_MTHD_VW

(SQL View)

Pymnt Methods using BANK_SETID

SELECT a.setid ,a.bank_cd ,a.bank_acct_key ,a.pymnt_method ,a.form_id ,b.form_type ,a.form_id_misc ,a.last_form_nbr_used ,a.eft_hdr_comment ,a.last_eft_file_id ,a.form_nbr_confirm ,a.positive_pay_flg ,a.form_id_pos ,a.file_copy_flg ,a.file_copy_form FROM PS_BANK_ACCT_MTHD a , ps_pymnt_form b WHERE a.form_id=b.form_id

Parent record: BANK_ACCT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

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

3 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

4 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

5 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

6 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

7 FORM_ID_MISC Character(6) VARCHAR2(6) NOT NULL Form for Notifications

8 LAST_FORM_NBR_USED Number(10,0) DECIMAL(10) NOT NULL Last Ref Number

9 EFT_HDR_COMMENT Character(10) VARCHAR2(10) NOT NULL Header Comment

10 LAST_EFT_FILE_ID Character(4) VARCHAR2(4) NOT NULL Last File Number

11 FORM_NBR_CONFIRM Character(1) VARCHAR2(1) NOT NULL Confirm Numbers
Y/N Table Edit

12 POSITIVE_PAY_FLG Character(1) VARCHAR2(1) NOT NULL Positive Payment Flag
Y/N Table Edit

13 FORM_ID_POS Character(6) VARCHAR2(6) NOT NULL Positive Payment Form

14 FILE_COPY_FLG Character(1) VARCHAR2(1) NOT NULL File Copy

15 FILE_COPY_FORM Character(6) VARCHAR2(6) NOT NULL File Copy Form

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
3	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
4	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
5	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
6	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
7	FORM_ID_MISC	Character(6)	VARCHAR2(6) NOT NULL	Form for Notifications
8	LAST_FORM_NBR_USED	Number(10,0)	DECIMAL(10) NOT NULL	Last Ref Number
9	EFT_HDR_COMMENT	Character(10)	VARCHAR2(10) NOT NULL	Header Comment
10	LAST_EFT_FILE_ID	Character(4)	VARCHAR2(4) NOT NULL	Last File Number
11	FORM_NBR_CONFIRM	Character(1)	VARCHAR2(1) NOT NULL	Confirm Numbers Y/N Table Edit
12	POSITIVE_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Positive Payment Flag Y/N Table Edit
13	FORM_ID_POS	Character(6)	VARCHAR2(6) NOT NULL	Positive Payment Form
14	FILE_COPY_FLG	Character(1)	VARCHAR2(1) NOT NULL	File Copy
15	FILE_COPY_FORM	Character(6)	VARCHAR2(6) NOT NULL	File Copy Form