VNDR_LOC_EFFVW

#	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 Prompt Table: CURRENCY_CD_TBL
7	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
8	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
9	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
10	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
11	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
12	MATCH_OPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Newly added for R-JMACIA-NQ66A D=Default from Higher Level S=Specified
13	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: MTCH_CNTRL_VW1
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=No Y=Yes 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=Virtual Approver W=Approval Framework Default Value: D
18	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
19	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_HDR
20	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: BUYER_TBL_FS
21	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID Prompt Table: SETID_TBL
22	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor Prompt Table: VNDR_RETURN_VW
23	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location Prompt Table: VNDR_REM_LOC_VW
24	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location Default Value: 1 Prompt Table: VNDR_REMADDR_VW
25	ADDR_SEQ_NUM_ORDR	Number(5,0)	INTEGER NOT NULL	Ordering Location Default Value: 1 Prompt Table: VNDR_ORDADDR_VW
26	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
27	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
28	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location Prompt Table: VNDR_LOC_VW
29	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor Prompt Table: VNDR_RETURN_VW
30	RET_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Return to Address Default Value: 1 Prompt Table: VNDR_RETADDR_VW
31	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Prompt Table: DST_CNTRL_TBL
32	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
33	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
34	CNTRCT_DISP_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Contract Dispatch Method EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
35	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Primary Supplier Prompt Table: VNDR_RETURN_VW
36	PRIM_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Invoicing Location Default Value: 1 Prompt Table: VNDR_INVADDR_VW
37	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_TBL
38	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination Prompt Table: SHIPTO_TBL
39	SALETX_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Tolerance Amount
40	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code Prompt Table: CURRENCY_CD_TBL
41	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
42	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type Prompt Table: RT_TYPE_TBL
43	SALETX_CD_ERS	Character(8)	VARCHAR2(8) NOT NULL	ERS Sales Tax Cd Prompt Table: TAX_USE_VW
44	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
45	AUTO_ASN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Advanced Shipment Notification Y/N Table Edit Default Value: N
46	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
47	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
48	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code Prompt Table: WTHD_CD_VNDR_VW
49	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
50	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
51	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
52	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
53	RTV_NOTIFY_METH	Character(3)	VARCHAR2(3) NOT NULL	RTV Notification Method EML=Electronic Mail PHN=Phone Default Value: PHN
54	RTV_DEBIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Return To Vendor Debit Memo Option D=Default N=No Y=Yes Default Value: D
55	VNDR_SBI_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow SBI Y/N Table Edit Default Value: N
56	SBI_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	SBI Approval Option A=Approved U=Unapproved Default Value: A
57	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT
58	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: %EDIT_ALTACCT
59	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
60	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
61	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
62	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
63	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
64	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
65	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
66	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
67	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
68	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
69	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
70	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
71	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
72	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
73	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag Y/N Table Edit Default Value: N
74	VCHR_CONSIGN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Consigned Voucher Option A=Automatic Creation M=Manual Creation S=Stage Pending Voucher
75	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence 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 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
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 N=None S=Stage to Pending File Default Value: D
80	ERS_INV_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date Option F=Frt Terms R=Recv Date
81	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
82	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
83	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
84	LAST_SBI_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Last SBI Number Used Default Value: 0
85	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
86	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
87	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
88	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
89	VAT_SUSPENSION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use VAT Suspension Y/N Table Edit Default Value: N
90	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
91	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 Default Value: PRN
92	VNDR_UPN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Universal Product Number Ready Flag Y/N Table Edit Default Value: N