VENDOR_LOC_M

#	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
9	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
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.
12	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID Prompt Table: SETID_TBL
13	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
14	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
15	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location Default Value: 1
16	ADDR_SEQ_NUM_ORDR	Number(5,0)	INTEGER NOT NULL	Ordering Location Default Value: 1
17	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
18	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
19	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
20	RETURN_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Return to Vendor
21	RET_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Return to Address Default Value: 1
22	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
23	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Primary Supplier
24	PRIM_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Invoicing Location Default Value: 1