RS_FR_UTL_HIST

(SQL Table)
Index Back

Supply Forecast History Table

ESA for IT: Supply Forecast History Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FORECAST_ID_SUP Character(15) VARCHAR2(15) NOT NULL Supply Forecast ID

Default Value: RS_FR_SUP_HDR.FORECAST_ID_SUP

2 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number
3 UPDATE_ACTION Character(1) VARCHAR2(1) NOT NULL Update Action Codes
A=Add
D=Delete
U=Update
4 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID
5 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
6 UTIL_PCT_HIST Signed Number(4,0) DECIMAL(3) NOT NULL Historical Utilization Percentage
7 UTIL_PCT Signed Number(4,0) DECIMAL(3) NOT NULL Utilization Percentage
8 COMMENTS Long Character CLOB Comment
9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
11 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
12 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.