VND_DFHI_OPTVW3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099
5	VAT_SW	Character(1)	VARCHAR2(1) NOT NULL	Display VAT Flag H=Hide VAT checkbox N=Display VAT checkbox off Y=Display VAT checkbox on
6	INTERUNIT_VNDR_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Vendor N=No Y=Yes
7	VNDR_AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Vendor Affiliate
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
10	SBI_FLG	Character(1)	VARCHAR2(1) NOT NULL	Selfbillingflag
11	SBI_DOC_OPT	Character(1)	VARCHAR2(1) NOT NULL	SelfBillingNumber G=Group Vouchers (Auto-Num) I=Individual Voucher (Auto-Num) P=Individual Vchr-Invoice Number
12	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
13	PAY_SCHEDULE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Pay Schedule Type MAN=Manual OTH=Other Non Transportation TRN=Transportation
14	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
15	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
16	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
17	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework
18	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
19	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set
20	DOC_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Type Flag D=Default from Higher Level S=Specify at This level
21	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
22	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
23	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
24	SALETX_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Tolerance Flag D=Default from Higher Level S=Specify at this Level
25	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
26	SALETX_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Tolerance Amount
27	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code
28	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type
29	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Acct Date C=Doc Date I=Inv Date R=Recpt Date S=Ship Date U=User Date
30	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match
31	DELAY_DAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Delay Days Flag D=Default from BU N=Do Not Employ S=Specify
32	PYMNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Payment Delay Days
33	DSCNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Discount Delay Days
34	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable
35	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
36	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month
37	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code
38	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
39	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
40	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
41	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
42	DUP_INVOICE_IND	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Indicator D=Default from Higher Level S=Specify at this Level
43	DUP_INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Severity K=Reject R=Recycle W=Warning
44	DUP_INV_COMB_CODE	Number(3,0)	SMALLINT NOT NULL	Dupl Invoice Combination Code
45	LATE_CHRG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Late Charges D=Default from Higher Level S=Specify
46	LATE_CHRG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Late Charge Option C=Compute Charges N=Not Applicable
47	LATE_CHRG_CD	Character(4)	VARCHAR2(4) NOT NULL	Late Charge Code
48	PYMNT_GROUP_CD	Character(2)	VARCHAR2(2) NOT NULL	Pay Group Code
49	ADDR_SEQ_NUM_ORDR	Number(5,0)	INTEGER NOT NULL	Ordering Location
50	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
51	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code
52	ERS_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Sales Tax N=No Taxes U=Use Tax V=Value Added Tax
53	VAT_SVC_PERFRM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Where VAT Services Physically Performed Flag 1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location
54	MATCH_DELAY_DAYS	Number(3,0)	SMALLINT NOT NULL	Match Delay Days
55	ALLOW_DEBIT_MEMO	Character(1)	VARCHAR2(1) NOT NULL	Allow Debit Memo
56	DBMEMO_DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Debit Memo Dispatch Method EDX=EDI/XML EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
57	DBMEMO_ADDR_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Debit Memo Address Option C=Supplier Contact Address D=Supplier Debit Memo Address R=Supplier Remit to Address
58	DM_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number used in Debit Memo options for a vendor location.
59	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
60	MATCH_DELAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy. D=Default from Higher Level S=Specified at This Level