SF_VNDRLOC_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 NOT NULL	Effective Date
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
8	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
9	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
10	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
11	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
12	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Payment Terms ID
13	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rules
14	MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requires Matching Y/N Table Edit Default Value: N
15	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=None O=Override Rules V=Create Voucher Default Value: N
16	ERS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Eval Rcpt Settlement Y/N Table Edit Default Value: N
17	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
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	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	VAT declaration point. D=Delivery I=At Invoice Time P=At Payment Time
21	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT calculation type. E=Exclusive I=Inclusive N=Not Applicable
22	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type
23	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
24	VAT_TOL_PCT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	VAT Tolerance Percentage
25	VAT_TOL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	VAT Tolerance Amount
26	VAT_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency
27	VAT_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Rate Type
28	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
29	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Name
30	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit Setid
31	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
32	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
33	REMIT_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Remitting Location Default Value: 1
34	ADDR_SEQ_NUM_ORDR	Number(3,0)	SMALLINT NOT NULL	Ordering Location Default Value: 1
35	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price from Vendor SetID
36	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
37	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
38	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor
39	RET_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Return to Address Default Value: 1
40	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
41	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language E=English F=French
42	RFQ_DISP_MTHD	Character(3)	VARCHAR2(3) NOT NULL	RFQ Dispatch Method EDI=Electronic Data Interchange FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
43	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Invoice Vendor
44	PRIM_ADDR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Invoicing Location Default Value: 1
45	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
46	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
47	SALETX_TOL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sales Tax Tolerance Amount
48	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code
49	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
50	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type
51	SALETX_CD_ERS	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Code ERS
52	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
53	AUTO_ASN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Advanced Shipment Notification Y/N Table Edit Default Value: N
54	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
55	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
56	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code
57	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Document Type L=Letter N=Notice O=Other Q=Request R=Report
58	DOC_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Type Flag D=Default S=Specify Default Value: D
59	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
60	RTV_NOTIFY_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Notification Method EML=Electronic Mail PHN=Phone Default Value: PHN
61	RTV_DEBIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	RTV Debit Option D=Default N=No Default Value: D
62	VNDR_SBI_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow SBI Y/N Table Edit Default Value: N
63	SBI_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	SBI Approval Option A=Approved U=Unapproved Default Value: A
64	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
65	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
66	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
67	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
68	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
69	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
70	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
71	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
72	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
73	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
74	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
75	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
76	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
77	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
78	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
79	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
80	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Y/N Table Edit Default Value: N
81	VCHR_CONSIGN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Consigned Voucher Option A=Automatic Creation M=Manual Creation S=Stage Pending Voucher
82	ERS_INV_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date Option F=Freight Terms R=Receipt Date
83	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Seq Number
84	ACCT_TEMPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Accounting Template D=Default from Higher Level S=Specify at this Level Default Value: D
85	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
86	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match Y/N Table Edit Default Value: N
87	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
88	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
89	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
90	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
91	LAST_SBI_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Last SBI Number Used
92	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
93	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
94	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
95	VAT_SUSPENSION_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT suspension. Y/N Table Edit Default Value: N
96	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
97	COMMENTS_2000	Long Character(32700)	CLOB	Comments Text