SF_VENDOR_PAY

#	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	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
10	PYMNT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Payment on hold. Y/N Table Edit Default Value: N
11	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Paygroup code.
12	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment Y/N Table Edit Default Value: Y
13	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
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(11)	VARCHAR2(11) NOT NULL	Bank ID
19	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	Bank account.
20	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
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 Reqd Y/N Table Edit Default Value: N
28	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Completed N=Not Submitted 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
35	EFT_PAY_INST_CD2	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 2
36	EFT_PAY_INST_CD3	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 3
37	EFT_PAY_INST_CD4	Character(3)	VARCHAR2(3) NOT NULL	Payment Instruction 4
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 Default Value: N
42	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
43	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Pay permit in next month Default Value: N
44	MIN_DFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Minimum Draft Amount
45	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
46	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
47	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date Y/N Table Edit Default Value: N