generated: 09.12.2016 10:27:53
by UC2010.accdb

AE Database 12.0 (Step 013)

Name	Type	Len	Attributes	Description
LASLM_Client	Integer	2	UC: Null=True	number of the client
LASLM_AH_Idnr	Long Integer	4	UC: Null=False	reference to AH of SLO
LASLM_SloName	Text	200	UC: Null=True	SLO object name
LASLM_ServName	Text	200	UC: Null=True	Service object name
LASLM_ServOType	Text	8	UC: Null=True	Service object type
LASLM_ServRunId	Long Integer	4	UC: Null=True	Service RunId
LASLM_ServFStatus	Long Integer	4	UC: Null=True	Service fulfillment status/ status message number
LASLM_ServMsgNr	Long Integer	4	UC: Null=True	reason of violation
LASLM_ServMsgIns	Text	255	UC: Null=True L=1024	message insert
LASLM_ServOH_Idnr	Long Integer	4	UC: Null=True	reference to OH of service object
LASLM_DetectTime	Date/Time	8	UC: Null=True	Fulfillment detection time
LASLM_Idnr	Long Integer	4	UC: Null=False Typ=Auto	Auto increment field as primary key
LASLM_Date	Date/Time	8	UC: Null=True	date, used to check if there is already an entry for a certain day. Contains only the date, no time
LASLM_OH_Idnr	Long Integer	4	UC: Null=True	OH_Idnr of the SLO objec
LASLM_LastUpdate	Date/Time	8	UC: Null=True	Timestamp updated whenever a row is changed in LASLM to help analytics to identify new data

Indexes:

Name	Fields
NK_LASLM_DetectTime	LASLM_DetectTime
NK_LASLM_ServRunId	LASLM_ServRunId
NK_LASLM_SloName	LASLM_SloName
PK_LASLM	LASLM_Idnr

Return to the Index File