VENDOR_LOC_E

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
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 Default Value: %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 Prompt Table: CURRENCY_CD_TBL
8	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
9	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
10	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
11	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
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. Prompt Table: PYMT_TR_EFF_VW
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	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 Default Value: D
19	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
20	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_HDR
21	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
22	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount." E=Exclusive I=Inclusive
23	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. Prompt Table: VAT_TXN_CD
24	VAT_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates at what level PeopleSoft General Ledger should handle the difference between VAT amount and the calculated VAT amount. The tolerance check, either as an amount or a percentage, can be specified at the Journal Source, Account, or Business Unit level. D=Default from Higher Level S=Specify at this Level Default Value: D
25	VAT_TOL_PCT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Specifies the allowable percentage difference between an entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
26	VAT_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the allowable amount difference between the entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
27	VAT_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency code for a specified VAT tolerance amount (VAT_TOL_AMT). Prompt Table: CURRENCY_CD_TBL
28	VAT_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Identifies the type of currency exchange rate used to convert the VAT Tolerance amount from its entry currency to the base currency of the business unit. Prompt Table: RT_TYPE_TBL
29	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type Prompt Table: VAT_USE_TBL
30	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_TBL_FS
31	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID Prompt Table: SETID_TBL
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(5,0)	INTEGER NOT NULL	Remitting Location Default Value: 1
35	ADDR_SEQ_NUM_ORDR	Number(5,0)	INTEGER 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 Prompt Table: VNDR_LOC_VW2
39	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor
40	RET_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Return to Address Default Value: 1
41	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Prompt Table: DST_CNTRL_TBL
42	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
43	RFQ_DISP_MTHD	Character(3)	VARCHAR2(3) NOT NULL	RFQ Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
44	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Primary Supplier
45	PRIM_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Invoicing Location Default Value: 1
46	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_TBL
47	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination Prompt Table: SHIPTO_TBL
48	SALETX_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Tolerance Amount
49	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code Prompt Table: CURRENCY_CD_TBL
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 Prompt Table: RT_TYPE_TBL
52	SALETX_CD_ERS	Character(8)	VARCHAR2(8) NOT NULL	ERS Sales Tax Cd Prompt Table: TAX_USE_VW
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 Prompt Table: WTHD_CD_VNDR_VW
58	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. Prompt Table: DOC_TYPE_TBL
59	DOC_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Document Type Flag D=Default from Higher Level S=Specify at This level Default Value: D
60	RTV_DISPATCH_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Dispatch Method EDX=Electronic Document Exchange EML=Electronic Mail FAX=Fax Transmission PHN=Phone 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	Return To Vendor Debit Memo Option D=Default N=No Y=Yes 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 Prompt Table: PO_ACCT_SET_VW
66	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: PO_ALTAC_SET_VW
67	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
68	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
69	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
70	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
71	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
72	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
73	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
74	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
75	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
76	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
77	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
78	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
79	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
80	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
81	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Y/N Table Edit Default Value: N
82	VCHR_CONSIGN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Consigned Voucher Option A=Automatic Creation M=Manual Creation S=Stage Pending Voucher
83	ERS_INV_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date Option F=Frt Terms R=Recv Date
84	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
85	ACCT_TEMPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Accounting Template D=Default from Higher Level S=Specify at this Level Default Value: D
86	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 Default Value: D
87	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match Y/N Table Edit Default Value: N
88	VCHR_MTCH_ADJ_DFLT	Character(1)	VARCHAR2(1) NOT NULL	Match Adjustments A=Automatic D=Default N=None S=Stage to Pending File Default Value: D
89	ERS_INV_DT_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date D=Default from Higher Level F=Freight Terms R=Receipt Date Default Value: D
90	ERS_TAX_TYPE_DFLT	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Sales Tax D=Default from Higher Level N=No Taxes U=Use Tax V=Value Added Tax Default Value: D
91	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
92	LAST_SBI_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Last SBI Number Used
93	SBI_DOC_DFLT	Character(1)	VARCHAR2(1) NOT NULL	SBI Numbering Option D=Default from Higher Level G=Group Vouchers (Auto-Num) I=Individual Voucher (Auto-Num) P=Individual Vchr-Invoice Number Default Value: D
94	SBI_PRINT_OPT	Character(1)	VARCHAR2(1) NOT NULL	SBI Printing Options, Default = 'B' B=Print Report and Files F=Print SBI File Only R=Print Report Only Default Value: B
95	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
96	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
97	VAT_SUSPENSION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use VAT Suspension Y/N Table Edit Default Value: N
98	REPL_DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	repl_disp_method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
99	COMMENTS_2000	Long Character	CLOB	Comment Text