VNDR_PAY_EFFVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: USD Prompt Table: CURRENCY_CD_TBL
8	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
9	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
10	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Hold Payment N=No Y=Yes Y/N Table Edit Default Value: N
11	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code Prompt Table: VNDR_PAYGRP_TBL
12	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit Default Value: N
13	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: PYMNT_HNDL_TBL
14	DSCNT_ALWAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always take discount Y/N Table Edit Default Value: N
15	DELAY_DAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Delay Days Flag D=Default from BU N=Do Not Employ S=Specify Default Value: D
16	DSCNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Discount Delay Days
17	PYMNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Payment Delay Days
18	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BNK_CD_CORP_VW
19	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 Prompt Table: BNK_ACT_CORP_VW
20	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency Prompt Table: BANK_CURR_AP_VW
21	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
22	EFT_PYMNT_FMT_CD	Character(3)	VARCHAR2(3) NOT NULL	Payment Format 00=Standard SWIFT transfer 10=Urgent SWIFT 15=Euro-Transfer 21=Check, w/ receipt confirmation 22=Check, Urgent 23=Check, urgent w/ receipt 40=Postal Order CTX=Corp Trade Exchange PBC=Check, standard PPD=Prearranged Pay & Deposit WRT=Wire Transfer
23	EFT_RTNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Complex Routing D=Use DFI ID N=None R=Use Complex Routing Default Value: D
24	EFT_RTNG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Routing Status C=Complete I=Incomplete Default Value: I
25	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice Default Value: X
26	PRENOTE_DATE	Date(10)	DATE	Prenotification Date
27	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Required Y/N Table Edit Default Value: N
28	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Confirmed N=New P=Pending R=Rejected S=Submitted
29	EFT_DOM_COSTS_CD	Character(1)	VARCHAR2(1) NOT NULL	Domestic Costs 1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account 4=Trans Exp to Pyr, other to Pye
30	EFT_CORR_COSTS_CD	Character(1)	VARCHAR2(1) NOT NULL	Correspondent's Costs 1=Payer's Domestic Account 2=Payer's Foreign Account 3=Payee's Account
31	EFT_CROSSED_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Crossed Check Y/N Table Edit Default Value: N
32	EFT_CHECK_FWRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Check Forwarding 1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank
33	EFT_CHECK_DRAW_CD	Character(1)	VARCHAR2(1) NOT NULL	Bank Check Drawn On 1=Payer's Bank 2=Payee's Bank
34	EFT_PAY_INST_CD1	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 1 ACC=/ACC/ BEN=/BENONLY/ CHK=/CHECK/ COR=/CORPTRAD/ HLD=/HOLD/ INT=/INT/ IRR=PAYMENT IRREVOCABLE PHB=/PHONEBEN/ PHI=/PHONIBK/ PHN=/PHON/ RC1=ADV BEN W/CHARGES RC2=ADV BEN W/O CHARGES RCB=/RCB/ REC=/REC/ REJ=/REJT/ RET=BEN UNKNOWN RETURN TEB=/TELEBEN/ TEI=/TELEIBK/ TEL=/TELE/ XFR=INTERCOMPANY TRANSFER Prompt Table: EFT_PAY_INST_VW
35	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2 Prompt Table: EFT_PAY_INST_VW
36	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3 Prompt Table: EFT_PAY_INST_VW
37	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4 Prompt Table: EFT_PAY_INST_VW
38	EFT_PAY_INST_REF1	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 1
39	EFT_PAY_INST_REF2	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 2
40	FACTORING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Factoring Y/N Table Edit Default Value: N
41	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
42	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
43	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month Y/N Table Edit Default Value: N
44	DFT_VNDR_PARAMS	Character(1)	VARCHAR2(1) NOT NULL	Draft Vendor Parameters Y/N Table Edit Default Value: N
45	DFT_OPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Draft Optimization D=Use Pay Cycle Default N=Do Not Use S=Specify Default Value: N
46	DFT_MAX_NUM	Number(2,0)	SMALLINT NOT NULL	Max Number of Drafts
47	DFT_ROUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Draft Rounding D=Use Pay Cycle Default N=Do Not Use S=Specify Default Value: N
48	DFT_AMT_POS	Number(2,0)	SMALLINT NOT NULL	Rounding Position
49	DFT_REMAIN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Remaining Amount Action A=Alternate Pay Mthd N=Do not issue Draft Default Value: N
50	PYMNT_METHOD_ALT	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House CHK=System Check DD=Direct Debit EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check WIR=Wire Report
51	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date Y/N Table Edit Default Value: N
52	APPLY_NETTING	Character(1)	VARCHAR2(1) NOT NULL	Apply Netting Y/N Table Edit Default Value: N
53	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code Prompt Table: APD_SIGHTCD_TBL
54	BCH_TRNCOST_CD	Character(1)	VARCHAR2(1) NOT NULL	Transfer Cost Code 1=Payer 2=Payee Default Value: 1
55	BCH_CALC_SRC	Character(1)	VARCHAR2(1) NOT NULL	Bank Charge source T=Table U=User Specified
56	BCH_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency CD Prompt Table: CURRENCY_CD_TBL
57	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
58	SMT_SPLIT_ID	Character(5)	VARCHAR2(5) NOT NULL	Payment Split ID Prompt Table: SMT_SPLIT_HD_VW
59	SMT_SPLIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Payment Split Y/N Table Edit Default Value: N