Definition of table: OKB - calendar keywords

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