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