UTIL_SETUP_INV (SQL Table)	Index Back
Utilization Type Rules Setup

UTIL_SETUP_INV

(SQL Table)

Utilization Type Rules Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
Default Value: CYCL

3 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

4 METRIC_CD Character(1) VARCHAR2(1) NOT NULL Percent or Static
2=Percent
4=Static
Default Value: 4

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW
2	UTILIZ_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Utilization Group CYCL=Cycle Count Default Value: CYCL
3	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
4	METRIC_CD	Character(1)	VARCHAR2(1) NOT NULL	Percent or Static 2=Percent 4=Static Default Value: 4