ITM_LOAD_VND_EC

#	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	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. Default Value: ITM_LOAD_PUR_EC.ECQUEUEINSTANCE
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VENDOR_LOC
8	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
9	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: ITM_LOAD_MST_EC.UNIT_MEASURE_STD Prompt Table: UNITS_TBL
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: ITM_LOAD_PUR_EC.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
11	QTY_MIN	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Quantity Default Value: 1
12	LOADED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Item Load Step One Load Status C=Complete L=To Be Loaded Default Value: L
13	ITM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status A=Active D=Discntued H=Hold I=Inactive X=To be Del Default Value: A
14	ACCEPT_ALL_UOM	Character(1)	VARCHAR2(1) NOT NULL	Accept Any UOM Y/N Table Edit Default Value: Y
15	ACCEPT_ALL_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Accept Any Ship To Y/N Table Edit Default Value: ITM_LOAD_PUR_EC.ACCEPT_ALL_SHIPTO
16	QTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Quantity to Use for Prices L=Line Quantity S=Schedule Quantity Default Value: L
17	PRICE_DT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Date to Use for Prices D=Due Date P=PO Date Default Value: P
18	PRICE_CAN_CHANGE	Character(1)	VARCHAR2(1) NOT NULL	Price Can Be Changed on Order N=No Y=Yes Y/N Table Edit Default Value: Y
19	VNDR_CATALOG_ID	Character(20)	VARCHAR2(20) NOT NULL	Vendor's Catalog Number
20	EFFDT_CATALOG	Date(10)	DATE	Catalog Effective Date Default Value: %Date
21	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
22	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
23	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
24	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
25	DFLT_UOM	Character(1)	VARCHAR2(1) NOT NULL	Vendor Default UOM Y/N Table Edit
26	PRICE_VNDR	Number(16,5)	DECIMAL(15,5) NOT NULL	Vendor Price Default Value: ITM_LOAD_PUR_EC.PRICE_LIST
27	QTY_PRECISION	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal W=Whole Nbr Default Value: D
28	ROUND_TOL	Signed Number(12,4)	DECIMAL(10,4) NOT NULL	Rounding Tolerance
29	LEAD_TIME_IMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Lead Time Factor % Default Value: ITM_LOAD_PUR_EC.LEAD_TIME_IMP
30	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
31	PV_CP_PART_EXT	Character(50)	VARCHAR2(50) NOT NULL	CUP Part Extension
32	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
33	STD_ID_NUM_VNDR	Character(20)	VARCHAR2(20) NOT NULL	Vendor ID Number
34	FILEPATH	Character(30)	VARCHAR2(30) NOT NULL	File Information
35	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension Default Value: ITM_LOAD_PUR_EC.FILE_EXTENSION
36	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
37	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)