Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
FH_Client smallint NUMBER(38,0) smallint smallint false client
FH_Title varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Title of the forecast
FH_Idnr int NUMBER(38,0) int int false primary key of the forecast
FH_AH_Idnr int NUMBER(38,0) int int true reference to the executive header (EH)
FH_USR_Idnr int NUMBER(38,0) int int true executing user
FH_LStartTime datetime DATE timestamp timestamp true Logical startdate and time
FH_LEndTime datetime DATE timestamp timestamp true Logical enddate and time
FH_CStartTime datetime DATE timestamp timestamp true Computation startdate and time of forecast
FH_CEndTime datetime DATE timestamp timestamp true Computation enddate and time of forecast
FH_Status int NUMBER(38,0) int int true Forecast status
FH_MsgNr int NUMBER(38,0) int int true Error message number
FH_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Insert for error message number
FH_UseEntries char (1) CHAR (1 CHAR) char(1) char (1) true deprecated (since 12.3.0): 1=Calculate groups through entries 0=do not calculate groups
FH_GroupRT int NUMBER(38,0) int int true deprecated (since 12.3.0): Runtime of groups if not calcualted, -1 means use ERT of group
FH_LDate datetime DATE timestamp timestamp true Logical Date
FH_Signal int NUMBER(38,0) int int true deprecated (since 12.3.0): Signals in any task (bitmask): 1=TCP exceeded, 2=MRT exceeded, 4=SRT not reached
FH_Type varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Type of forecast: FCST=Object or Execution Forecast, AFCST=Autoforecast
FH_TZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true deprecated (since 12.3.0): Timezone for this forecast
FH_ContainerType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true deprecated (since 12.3.0): Object type of children
FH_NextCheck datetime DATE timestamp timestamp true deprecated (since 12.3.0): Evnt: time when the event will be checked the next time, Call-Op: time when to escalate, schedule: end of the period
FH_Timespan int NUMBER(38,0) int int true deprecated (since 12.3.0): Duration of Forecast (for periodic activities)
FH_LastEnd datetime DATE timestamp timestamp true deprecated (since 12.3.0): Last end time of preceding job in period
FH_OccurCount int NUMBER(38,0) int int true deprecated (since 12.3.0): number of occurred activities in period
FH_AEVersion varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true AE system version
FH_Count int NUMBER(38,0) int int true Number of sent forecast messages
FH_Bacv int NUMBER(38,0) int int true In case that we need to send quitt to WP bacv is saved here
FH_BsrName varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true In case that we need to send quitt to WP, routine name is saved here

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_FH FH_Idnr true true true false
UK_FH_Title FH_Client, FH_Title false true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File