UPG_IN_UTIL_TAO (SQL Table)	Index Back
Upgrade for ABC Calc Used for upgrade for ABC Calculations

UPG_IN_UTIL_TAO

(SQL Table)

Upgrade for ABC Calc

Used for upgrade for ABC Calculations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	UTILIZ_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Utilization Group CYCL=Cycle Count
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