OKB_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
reference to the object header (OH) |
OKB_Lnr |
smallint |
NUMBER(38,0) |
smallint |
false |
ascending number of the keyword |
OKB_Name |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
name of the calendar keyword |
OKB_DefFrom |
datetime |
DATE |
timestamp |
true |
default from time |
OKB_DefTo |
datetime |
DATE |
timestamp |
true |
default to time |
OKB_CType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
Calendar Type (Y=Yearly, M=Monthly, W=Weekly, S=Static, R=Roll, G=Group, O=Old fashioned CALE) |
OKB_SType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
Calendar Sub Type (A=Absolute, R=Relative, I=Interval, ' ' none (roll or group) |
OKB_ValidFrom |
datetime |
DATE |
timestamp |
true |
Valid from Static: user defined period, Valid from Dynamic: calculated period |
OKB_ValidTo |
datetime |
DATE |
timestamp |
true |
Valid to Static: user defined period, Valid to Dynamic: calculated period |
OKB_MsgNr |
int |
NUMBER(38,0) |
int |
true |
Message Numer for national holiday calendars |
OKB_ErrMsgNr |
int |
NUMBER(38,0) |
int |
true |
Error Message Number (0 -> Errorfree else Error) |
OKB_ErrMsgInsert |
varchar (1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
true |
Error Message Insert |
OKB_Period |
smallint |
NUMBER(38,0) |
smallint |
true |
Period (every n) |
OKB_PeriodStart |
smallint |
NUMBER(38,0) |
smallint |
true |
Perod start (e.g. month 02) |
OKB_PeriodEnd |
smallint |
NUMBER(38,0) |
smallint |
true |
Period end (e.g. To month 02) |
OKB_DefDays |
varchar(2600) |
VARCHAR2 (2600 CHAR) |
varchar(2600) |
true |
Defined Days (24.12;31.12;) or (1;3;12) or (SU;MO;WE) |
OKB_Interval |
smallint |
NUMBER(38,0) |
smallint |
true |
Interval (every n days) |
OKB_Direction |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
From B(egin) E(nd) |
OKB_IntervalStart |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
Start of Interval (DDMM or DD) |
OKB_IntervalEnd |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
true |
End of Interval (DDMM or DD) |
OKB_RCaleName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Name of calendar (basis for roll calendar) |
OKB_RCaleKeyName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Name of calendar keyword (basis for roll calendar) |
OKB_RCaleAdjust |
smallint |
NUMBER(38,0) |
smallint |
true |
Adjust plus/minus days |
OKB_RCaleOperator |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
Operator for roll calendar ('+'=shift forward,' '-=shift backward |
OKB_RCaleOffset |
smallint |
NUMBER(38,0) |
smallint |
true |
plus/minus days for roll calendar (0=adjust to next workingday according to operator; >0=adjust to next workingday according to operator + offset workingdays |
OKB_RCaleRef |
smallint |
NUMBER(38,0) |
smallint |
true |
Use reference calendar (e.g. workingdays) |
OKB_RRCaleName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Ref. calendar name |
OKB_RRCaleKeyName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Ref. calendar key name |