IN_UTIL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	UTILIZ_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Utilization Group CYCL=Cycle Count
4	REQUIRED_RULE	Character(3)	VARCHAR2(3) NOT NULL	Required Rule 005=On Hand Quantity 010=On Hand Amount 015=Unit Cost 020=Lead Time (Days) 025=Historical Usage Quantity 030=Historical Usage Amount 035=Historical Adjustment Quantity 040=Historical Adjustment Amount 045=Historical # of Transactions 050=Forecasted Quantity 055=Forecasted Amount
5	METRIC_CD	Character(1)	VARCHAR2(1) NOT NULL	Percent or Static 2=Percent 4=Static
6	UTILIZ_CD	Character(4)	VARCHAR2(4) NOT NULL	Utilization Type
7	ONHAND_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	On Hand Quantity
8	ONHAND_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	On Hand Amount
9	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
10	LEAD_TIME_DAYS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Lead Time (Days)
11	HIST_USAGE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Hist Usage Amt
12	HIST_USAGE_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Historical Usage Quantity
13	HIST_ADJUST_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Hist Adjustment Amt
14	HIST_ADJUST_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Hist Adjustment Qty
15	HIST_NUM_TRANS	Number(10,0)	DECIMAL(10) NOT NULL	Hist # of Transactions
16	QTY_FORECAST	Number(16,4)	DECIMAL(15,4) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
17	AMT_FORECAST	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Forecasted Amount
18	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
19	UTILIZ_RPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Generate Report
20	UTILIZ_RPT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Modified 8/4/03 by David Bernardo - removed translate of N B=Both Summary and Detail Report D=Detail Report Only N=No Report S=Summary Report Only
21	UTILIZ_UPDT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Utilization Type
22	UPDATE_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Update Inventory Item
23	HIST_START_DT	Date(10)	DATE	Historical Start Date
24	FORCST_HORIZN_DT	Date(10)	DATE	Forecast Horizon Date
25	FORECAST_SET	Character(20)	VARCHAR2(20) NOT NULL	Forecast Set
26	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
27	SETID_CATALOG	Character(5)	VARCHAR2(5) NOT NULL	Catalog SetID
28	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
29	SETID_MST_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Master Item SETID
30	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
31	PO	Character(1)	VARCHAR2(1) NOT NULL	Purchasing
32	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
33	UTIL_SORT_FLD	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	Utilization Sort Field
34	UNIT_COST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Unit Cost
35	HIST_USE_AMT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hist Usage Amount
36	HIST_ADJ_AMT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hist Adjustment Amt
37	FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name
38	BUS_UNIT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Option A=All S=Specific
39	INV_ITEM_LIST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Item List Option A=All Items C=Category F=Item Family G=Item Group R=Range of Items S=Single Item
40	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
41	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
42	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family
43	FROM_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID
44	TO_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	To Item ID
45	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
46	BUSINESS_UNIT2	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
47	IP_PLANNING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Inventory Policy Planning Item
48	SETID_UNIQUE	Character(5)	VARCHAR2(5) NOT NULL	SetID
49	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code