Table EVP

Definition of table: EVP - validation period

generated: 12.12.2016 18:33:39
by UC2010.accdb

AE Database 11.2 (Step 018)

Name Type Len Attributes Description

EVP_AH_Idnr Long Integer 4 UC: Null=False reference to the executive header (EH)

EVP_Lnr Integer 2 UC: Null=False ascending number of the element

EVP_CaleName Text 200 UC: Null=True name of the calendar

EVP_CaleKeyName Text 200 UC: Null=True name of the calendar keyword

EVP_From Text 4 UC: Null=True HHMM from

EVP_To Text 4 UC: Null=True HHMM to

EVP_Status Long Integer 4 UC: Null=True state (aktive yes/no)

Name	Type	Len	Attributes	Description
EVP_AH_Idnr	Long Integer	4	UC: Null=False	reference to the executive header (EH)
EVP_Lnr	Integer	2	UC: Null=False	ascending number of the element
EVP_CaleName	Text	200	UC: Null=True	name of the calendar
EVP_CaleKeyName	Text	200	UC: Null=True	name of the calendar keyword
EVP_From	Text	4	UC: Null=True	HHMM from
EVP_To	Text	4	UC: Null=True	HHMM to
EVP_Status	Long Integer	4	UC: Null=True	state (aktive yes/no)

Indexes:

Name Fields

PK_EVP EVP_AH_Idnr, EVP_Lnr

Name	Fields
PK_EVP	EVP_AH_Idnr, EVP_Lnr

Return to the Index File