| 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 |