Table OKC

Definition of table: OKC - Collisions for Roll Calendar

generated: 09.12.2016 10:28:37
by UC2010.accdb

AE Database 12.0 (Step 013)

Name Type Len Attributes Description

OKC_OH_Idnr Long Integer 4 UC: Null=False reference to the object header (OH)

OKC_OKB_Lnr Integer 2 UC: Null=False reference to the keyword

OKC_Lnr Integer 2 UC: Null=False line number for sort order

OKC_CaleName Text 200 UC: Null=True collision calendar name

OKC_CaleKeyName Text 200 UC: Null=True collision calendar key name

OKC_Operator Text 1 UC: Null=True operator ('+'=forward, '-'=backward, 'S'=skip)

OKC_Offset Integer 2 UC: Null=True Offset by workingdays (0=adjust to next workingday according to operator, >0=adjust to next workingday according to operator + offset workingdays)

OKC_RCaleName Text 200 UC: Null=True Ref. calendar name

OKC_RCaleKeyName Text 200 UC: Null=True Ref. calendar key name

Name	Type	Len	Attributes	Description
OKC_OH_Idnr	Long Integer	4	UC: Null=False	reference to the object header (OH)
OKC_OKB_Lnr	Integer	2	UC: Null=False	reference to the keyword
OKC_Lnr	Integer	2	UC: Null=False	line number for sort order
OKC_CaleName	Text	200	UC: Null=True	collision calendar name
OKC_CaleKeyName	Text	200	UC: Null=True	collision calendar key name
OKC_Operator	Text	1	UC: Null=True	operator ('+'=forward, '-'=backward, 'S'=skip)
OKC_Offset	Integer	2	UC: Null=True	Offset by workingdays (0=adjust to next workingday according to operator, >0=adjust to next workingday according to operator + offset workingdays)
OKC_RCaleName	Text	200	UC: Null=True	Ref. calendar name
OKC_RCaleKeyName	Text	200	UC: Null=True	Ref. calendar key name

Indexes:

Name Fields

NK_OKC_Cale OKC_CaleName, OKC_CaleKeyName

NK_OKC_RCale OKC_RCaleName, OKC_RCaleKeyName

PK_OKC OKC_OH_Idnr, OKC_OKB_Lnr, OKC_Lnr

Name	Fields
NK_OKC_Cale	OKC_CaleName, OKC_CaleKeyName
NK_OKC_RCale	OKC_RCaleName, OKC_RCaleKeyName
PK_OKC	OKC_OH_Idnr, OKC_OKB_Lnr, OKC_Lnr

Return to the Index File