SF_VNDRPAY_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	EFFDT	Date(10)	DATE	Effective Date
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
10	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Type or Method of payment. Indicator as to how the payment should be handled ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Customer Initiated Draft CHK=System Check DD=Direct Debit DFT=Vendor Initiated Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire Flat File WIR=Wire Report
11	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment on hold. Y/N Table Edit Default Value: N
12	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Paygroup code.
13	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit Default Value: Y
14	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment handling code. HD=High Dollar Payment IN=Internal Distribution PO=Route to Purchasing RE=Regular Payments
15	DSCNT_ALWAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always take discount Y/N Table Edit Default Value: N
16	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
17	DSCNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Discount Delay Days
18	PYMNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Payment delay days.
19	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
20	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bank account.
21	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
22	CUR_RT_TYPE_PYMNT	Character(5)	VARCHAR2(5) NOT NULL	Payment Currency Rate Type
23	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
24	EFT_RTNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Complex Routing D=Use DFI ID N=None R=Use Complex Routing Default Value: D
25	EFT_RTNG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Routing Status C=Complete I=Incomplete Default Value: I
26	EFT_TRANS_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Transaction Handling D=Payment Only P=Prenotification X=Payment and Advice Default Value: X
27	PRENOTE_DATE	Date(10)	DATE	Prenotification Date
28	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Reqd Y/N Table Edit Default Value: N
29	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Completed N=Not Submitted P=Pending R=Rejected S=Submitted
30	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
31	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
32	EFT_CROSSED_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Crossed Check Y/N Table Edit Default Value: N
33	EFT_CHECK_FWRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Check Forwarding 1=Payer's Bank 2=Payer 3=Payee 4=Payee's Bank
34	EFT_CHECK_DRAW_CD	Character(1)	VARCHAR2(1) NOT NULL	Bank Check Drawn On 1=Payer's Bank 2=Payee's Bank
35	EFT_PAY_INST_CD1	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 1
36	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2
37	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3
38	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4
39	EFT_PAY_INST_REF1	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 1
40	EFT_PAY_INST_REF2	Character(40)	VARCHAR2(40) NOT NULL	Payment Instruction Ref 2
41	FACTORING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Factoring Y/N Table Edit Default Value: N
42	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option Default Value: N
43	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
44	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Pay permit in next month Default Value: N
45	MIN_DFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Minimum Draft Amount
46	MIN_DFT_AMT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Minimum Draft Amount Option A=Alternative Payment Method N=Do not issue draft Default Value: N
47	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
48	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date Y/N Table Edit Default Value: N