VENDOR_LOC

#	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 NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
8	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
9	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
10	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDI=Electronic Data Interchange EML=E-Mail Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
11	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Payment Terms ID
12	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rules
13	MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requires Matching Y/N Table Edit Default Value: N
14	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=None O=Override Rules V=Create Voucher Default Value: N
15	ERS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Eval Rcpt Settlement Y/N Table Edit Default Value: N
16	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Specify at this Level Default Value: D
17	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
18	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_HDR
19	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	VAT declaration point. D=Delivery I=At Invoice Time P=At Payment Time
20	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT calculation type. E=Exclusive I=Inclusive N=Not Applicable
21	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type
22	VAT_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT tolerance check indicator. D=Default From igher Level S=Specify at this Level Default Value: D
23	VAT_TOL_PCT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	VAT Tolerance Percentage
24	VAT_TOL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	VAT Tolerance Amount
25	VAT_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency
26	VAT_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type
27	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
28	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Name
29	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Setid Prompt Table: SETID_TBL
30	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: VENDOR
31	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location Prompt Table: VNDR_REMLOC_VW
32	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location Default Value: 1 Prompt Table: VNDR_REMADDR_VW
33	ADDR_SEQ_NUM_ORDR	Number(3,0)	SMALLINT NOT NULL	Ordering Location Default Value: 1 Prompt Table: VENDOR_ADDR
34	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price from Vendor SetID
35	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID Prompt Table: VENDOR
36	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location Prompt Table: VENDOR_LOC
37	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor Prompt Table: VENDOR
38	RET_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Return to Address Default Value: 1 Prompt Table: VENDOR_ADDR
39	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
40	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language E=English F=French
41	RFQ_DISP_MTHD	Character(3)	VARCHAR2(3) NOT NULL	RFQ Dispatch Method EDI=Electronic Data Interchange FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
42	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Invoice Vendor Prompt Table: VENDOR
43	PRIM_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Invoicing Location Default Value: 1 Prompt Table: VENDOR_ADDR
44	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
45	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
46	SALETX_TOL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sales Tax Tolerance Amount
47	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code
48	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
49	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type
50	SALETX_CD_ERS	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Code ERS
51	SALES_USE_TX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Code N=Non Taxable S=Sales Tax U=Use Tax Default Value: N
52	AUTO_ASN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Advanced Shipment Notification Y/N Table Edit Default Value: N
53	SALETX_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Tolerance Flag D=Default from Higher Level S=Specify at this Level Default Value: D
54	SHIP_LOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Ship To/End Location Flag D=Default from Higher Level S=Specify at this Level Default Value: D
55	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code
56	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Document Type L=Letter N=Notice O=Other Q=Request R=Report
57	DOC_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Type Flag D=Default S=Specify Default Value: D
58	RTV_DISPATCH_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Dispatch Method EDI=Electronic Data Interchange EML=Electronic Mail FAX=Fax Transmission PRN=Print Default Value: PRN
59	RTV_NOTIFY_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Notification Method EML=Electronic Mail PHN=Phone Default Value: PHN
60	RTV_DEBIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	RTV Debit Option D=Default N=No Default Value: D
61	VNDR_SBI_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow SBI Y/N Table Edit Default Value: N
62	SBI_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	SBI Approval Option A=Approved U=Unapproved Default Value: A
63	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
64	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
65	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
66	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
67	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
68	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
69	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
70	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Y/N Table Edit Default Value: N
71	VCHR_CONSIGN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Consigned Voucher Option A=Automatic Creation M=Manual Creation S=Stage Pending Voucher
72	ERS_INV_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date Option F=Freight Terms R=Receipt Date
73	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Seq Number
74	ACCT_TEMPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Accounting Template D=Default from Higher Level S=Specify at this Level Default Value: D
75	PAY_TRM_BSE_DT_DFT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date A=Accounting Date B=Default C=Constructive Doc Receipt Date D=Default Higher level I=Invoice Date R=Receipt Date S=Ship Date U=User Specified Date Default Value: B
76	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match Y/N Table Edit Default Value: N
77	VCHR_MTCH_ADJ_DFLT	Character(1)	VARCHAR2(1) NOT NULL	Match Adjustments A=Automatic D=Default Higher N=None S=Stage to Pending File Default Value: D
78	ERS_INV_DT_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date D=Default Higher F=Freight Terms R=Receipt Date Default Value: D
79	ERS_TAX_TYPE_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Buyer's Sales Tax D=Default Higher N=None U=Use Tax V=Value Added Tax Default Value: D
80	ERS_TAX_CD_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Sale Tax Code Override D=Default from Ship To S=Specify Default Value: D
81	LAST_SBI_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Last SBI Number Used
82	SBI_DOC_DFLT	Character(1)	VARCHAR2(1) NOT NULL	SBI Document Option D=Default Higher G=Group Vouchers I=Individual Voucher P=Invoice Number Default Value: D
83	VCHR_TAX_ADJ_DFT	Character(1)	VARCHAR2(1) NOT NULL	Sales and Use Tax Adjustments A=Automatic D=Default N=None S=Stage to Pending File Default Value: D
84	RTV_VCHR_ADJ_DFLT	Character(1)	VARCHAR2(1) NOT NULL	RTV Adjustment Option A=Automatic Adjustment D=Default N=None S=Stage to Pending File Default Value: D
85	VAT_SUSPENSION_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT suspension. Y/N Table Edit Default Value: N
86	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
87	COMMENTS_2000	Long Character(32700)	CLOB	Comments Text