VENDOR_LOC_AET

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