BANK_COLCT_MTHD

#	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	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
6	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code Prompt Table: %EDITTABLE6
7	DD_NOTICE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Direct Debit Notice Period
8	DD_CLEARING_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Clearing Method B=Bank Recon D=Due Date N=None Default Value: N
9	LAST_EFT_FILE_ID	Character(4)	VARCHAR2(4) NOT NULL	Last File Number
10	COMPANY_ID	Character(20)	VARCHAR2(20) NOT NULL	Company ID - Company Tax ID
11	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
12	DRAFT_RISK_DAYS	Number(3,0)	SMALLINT NOT NULL	Draft Risk Days
13	CR_LIMIT_DT	Date(10)	DATE	Credit Limit Date
14	CR_LIMIT_REV_DT	Date(10)	DATE	Credit Limit Review Date
15	CR_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Limit
16	DR_MIN_REMIT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Min Remittance Amount
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
18	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable Default Value: N
19	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
20	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month Y/N Table Edit Default Value: N
21	VALUE_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	Value Date Y/N Table Edit
22	VALUE_DT_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Value Date Days
23	PAYMENT_TIME	Time(15)	TIMESTAMP	Represents the precise time of the day in which settlements will no longer be accepted by a given c
24	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Required Y/N Table Edit
25	AR_EBP_LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Direct Debit Lead Time Days Default Value: 0