Definition of table: XAO - Revision

generated: 12.12.2016 18:34:56
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
XAO_Idnr Long Integer 4 UC: Typ=Zähler Null=False Identifer for XAO
XAO_TimeStamp1 Date/Time 8 UC: Null=True Time of activation
XAO_Client Integer 2 UC: Null=True UC4 client
XAO_Type Text 8 UC: Null=True Record types - type identifier (start, modification, ...) readable
XAO_USR_Idnr Long Integer 4 UC: Null=True Reference to User
XAO_OH_Idnr Long Integer 4 UC: Null=True Idnr of affected object
XAO_OType Text 8 UC: Null=True Object type
XAO_Name Text 200 UC: Null=True Objekt name
XAO_OH_IdnrOld Long Integer 4 UC: Null=True Old OH_Idnr
XAO_AH_Idnr Long Integer 4 UC: Null=True Run number, session id
XAO_ParentAct Long Integer 4 UC: Null=True Activator (Run#)
XAO_MsgNr Long Integer 4 UC: Null=True Depending on record type: message number
XAO_MsgInsert Text 255 UC: Null=True L=1024 Depending on record type: message insert
XAO_Level Integer 2 UC: Null=True Level of revision for this record
XAO_ArchiveFlag Byte 1 UC: Null=True Flag if already evaluated (not used)
XAO_DeleteFlag Byte 1 UC: Null=True Flag for reorganisation


Indexes:

Name Fields
NK_XAO_Reorg XAO_ArchiveFlag, XAO_DeleteFlag, XAO_OH_IdnrOld, XAO_Idnr
PK_XAO XAO_Idnr


Return to the Index File