generated: 09.12.2016 10:28:35
by UC2010.accdb
AE Database 12.0 (Step 013)
| Name | Type | Len | Attributes | Description |
|---|---|---|---|---|
| OKB_OH_Idnr | Long Integer | 4 | UC: Null=False | reference to the object header (OH) |
| OKB_Lnr | Integer | 2 | UC: Null=False | ascending number of the keyword |
| OKB_Name | Text | 200 | UC: Null=True | name of the calendar keyword |
| OKB_DefFrom | Date/Time | 8 | UC: Null=True | default from time |
| OKB_DefTo | Date/Time | 8 | UC: Null=True | default to time |
| OKB_CType | Text | 1 | UC: Null=True | Calendar Type (Y=Yearly, M=Monthly, W=Weekly, S=Static, R=Roll, G=Group, O=Old fashioned CALE) |
| OKB_SType | Text | 1 | UC: Null=True | Calendar Sub Type (A=Absolute, R=Relative, I=Interval, ' ' none (roll or group) |
| OKB_ValidFrom | Date/Time | 8 | UC: Null=True | Valid from Static: user defined period, Valid from Dynamic: calculated period |
| OKB_ValidTo | Date/Time | 8 | UC: Null=True | Valid to Static: user defined period, Valid to Dynamic: calculated period |
| OKB_MsgNr | Long Integer | 4 | UC: Null=True | Message Numer for national holiday calendars |
| OKB_ErrMsgNr | Long Integer | 4 | UC: Null=True | Error Message Number (0 -> Errorfree else Error) |
| OKB_ErrMsgInsert | Text | 255 | UC: Null=True L=1024 | Error Message Insert |
| OKB_Period | Integer | 2 | UC: Null=True | Period (every n) |
| OKB_PeriodStart | Integer | 2 | UC: Null=True | Perod start (e.g. month 02) |
| OKB_PeriodEnd | Integer | 2 | UC: Null=True | Period end (e.g. To month 02) |
| OKB_DefDays | Memo | 0 | UC: Null=True L=2600 | Defined Days (24.12;31.12;) or (1;3;12) or (SU;MO;WE) |
| OKB_Interval | Integer | 2 | UC: Null=True | Interval (every n days) |
| OKB_Direction | Text | 1 | UC: Null=True | From B(egin) E(nd) |
| OKB_IntervalStart | Text | 4 | UC: Null=True | Start of Interval (DDMM or DD) |
| OKB_IntervalEnd | Text | 4 | UC: Null=True | End of Interval (DDMM or DD) |
| OKB_RCaleName | Text | 200 | UC: Null=True | Name of calendar (basis for roll calendar) |
| OKB_RCaleKeyName | Text | 200 | UC: Null=True | Name of calendar keyword (basis for roll calendar) |
| OKB_RCaleAdjust | Byte | 1 | UC: Null=True Typ=Boolean | Adjust plus/minus days |
| OKB_RCaleOperator | Text | 1 | UC: Null=True | Operator for roll calendar ('+'=shift forward,' '-=shift backward |
| OKB_RCaleOffset | Integer | 2 | UC: Null=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 | Byte | 1 | UC: Null=True Typ=Boolean | Use reference calendar (e.g. workingdays) |
| OKB_RRCaleName | Text | 200 | UC: Null=True | Ref. calendar name |
| OKB_RRCaleKeyName | Text | 200 | UC: Null=True | Ref. calendar key name |
Indexes:
| Name | Fields |
|---|---|
| NK_OKB_RCale | OKB_RCaleName, OKB_RCaleKeyName |
| NK_OKB_RRCale | OKB_RRCaleName, OKB_RRCaleKeyName |
| PK_OKB | OKB_OH_Idnr, OKB_Lnr |
| UK_OKB_Key | OKB_OH_Idnr, OKB_Name |
Return to the Index File