PO_ITMLOAD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	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.
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	QTY_MIN	Number(16,4)	DECIMAL(15,4) NOT NULL	Minimum Quantity
7	RUN_DT	Date(10)	DATE	Run Date
8	ITEM_ID_LAST_USED	Number(18,0)	DECIMAL(18) NOT NULL	Last Item Number Assigned
9	COUNTER1	Number(16,2)	DECIMAL(15,2) NOT NULL	Counter 1
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	ALL_SETID	Character(1)	VARCHAR2(1) NOT NULL	All Item SetIDs
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
14	ALL_MFG_ID	Character(1)	VARCHAR2(1) NOT NULL	All Manufacturers
15	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
16	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
17	ALL_VENDORS_FLG	Character(1)	VARCHAR2(1) NOT NULL	All Suppliers
18	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
19	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
20	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
21	USE_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Purchasing Dflts From Category
22	UPDATE_ATTR	Character(1)	VARCHAR2(1) NOT NULL	Update Attribute Tables
23	SETID_LAST	Character(5)	VARCHAR2(5) NOT NULL	Last SetID
24	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
25	DELETE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Delete Loaded Items
26	NUM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign ID N=For All New Items Y=When Item ID is not specified
27	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
28	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
29	INSERT_NEW_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create New Items N=Replace Rows Only O=Create New Only Y=New Items and Replace Rows
30	UPDATE_VNDR_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Update Item Supplier Price
31	UPDATE_ITM_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Update Item Supplier Tables
32	UPDATE_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Update Inventory Item
33	UPDATE_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Create New Categories
34	PREV_REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Prev Remit Setid
35	PREV_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	PREVIOUS ITEM ID
36	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID Prompt Table: SETID_VW
37	VNDR_SETID	Character(5)	VARCHAR2(5) NOT NULL	VENDOR SETID
38	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
39	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
40	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
41	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
42	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
43	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
44	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
45	FILE_EXTENSION	Character(4)	VARCHAR2(4) NOT NULL	File Extension