VENDOR_LOC_VW

#	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 Prompt Table: VNDR_VNDSET_VW
3	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
7	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
8	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
9	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
10	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.
11	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
12	PAY_TRM_BSE_DT_DFT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Accounting Date C=Constructive Doc Receipt Date D=Default from Higher Level I=Invoice Date R=Receipt Date S=Ship Date U=User Specified Date
13	MATCH_OPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Newly added for R-JMACIA-NQ66A D=Default from Higher Level S=Specified
14	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: MTCH_CNTRL_VW1
15	MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requires Matching Y/N Table Edit Default Value: N
16	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=No Y=Yes Default Value: N
17	ERS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Eval Rcpt Settlement Y/N Table Edit Default Value: N
18	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
19	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
20	CNTRCT_DISP_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Contract Dispatch Method EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
21	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
22	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
23	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code
24	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: N
25	ADDR_SEQ_NUM_ORDR	Number(5,0)	INTEGER NOT NULL	Ordering Location
26	VNDR_UPN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Universal Product Number Ready Flag Y/N Table Edit Default Value: N
27	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code Prompt Table: SUT_USE_CD
28	ADDR_SEQ_NUM_SHFR	Number(5,0)	INTEGER NOT NULL	Ship From Address Default Value: 1 Prompt Table: VNDR_SHFADDR_VW
29	CC_ACCEPT_CC	Character(1)	VARCHAR2(1) NOT NULL	Accept Procurement Card Y/N Table Edit Default Value: N
30	CC_DISP_OPTION	Character(1)	VARCHAR2(1) NOT NULL	ProCard Dispatch Option A=Default B=Include Masked Card Info C=Contact Buyer D=Contact Cardholder E=Charge to Card on File F=No Reference
31	CC_ALLOW_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow Override Vendor Card Y/N Table Edit Default Value: N
32	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
33	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N
34	SPLIT_PO_BY_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Split PO by Ship To B=Default from Higher Level N=Do Not Split PO by Ship To Y=Split PO by Ship To