PO_ITMLOAD_PARM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ALL_SETID	Character(1)	VARCHAR2(1) NOT NULL	All Item SetIDs Y/N Table Edit Default Value: Y
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_ITMSET_NONVW
5	ALL_VENDORS_FLG	Character(1)	VARCHAR2(1) NOT NULL	All Suppliers Y/N Table Edit Default Value: Y
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: ITMLD_VSETID_VW
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: ITMLD_VNDR_VW
8	ALL_MFG_ID	Character(1)	VARCHAR2(1) NOT NULL	All Manufacturers Y/N Table Edit Default Value: Y
9	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID Prompt Table: ITMLD_MFG_ID_VW
10	USE_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Purchasing Dflts From Category Y/N Table Edit Default Value: Y
11	DELETE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Delete Loaded Items Y/N Table Edit Default Value: Y
12	NUM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign ID N=For All New Items Y=When Item ID is not specified Default Value: Y
13	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 Y/N Table Edit Default Value: Y
14	UPDATE_VNDR_PRICE	Character(1)	VARCHAR2(1) NOT NULL	Update Item Supplier Price Y/N Table Edit Default Value: Y
15	UPDATE_ITM_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Update Item Supplier Tables Y/N Table Edit Default Value: Y
16	UPDATE_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Update Inventory Item Y/N Table Edit Default Value: Y
17	UPDATE_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Create New Categories Y/N Table Edit Default Value: Y
18	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID Prompt Table: SP_SETID_NONVW
19	VNDR_SETID	Character(5)	VARCHAR2(5) NOT NULL	VENDOR SETID Prompt Table: SP_SETID_NONVW