Definition of table: RH - report header

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

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
RH_Client Integer 2 UC: Null=False client
RH_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH)
RH_Type Text 4 UC: Null=False report type (reference to type UC_RTYP)
RH_TimeStamp1 Date/Time 8 UC: Null=True timestamp of report creation (open)
RH_TimeStamp4 Date/Time 8 UC: Null=True timestamp of report close
RH_DeleteFlag Byte 1 UC: Null=True delete flag
RH_ArchiveFlag Byte 1 UC: Null=True archive flag
RH_BlkSize Long Integer 4 UC: Null=True Bytes per block
RH_Title Text 200 UC: Null=True Alternate title of reports
RH_XMLFlag Byte 1 UC: Typ=Boolean Null=True Flag for XML Reports (0=not an XML Report, 1=XML Report)
RH_FileFullPath Text 50 UC: Null=True L=512 Full path name of output file
RH_FileOnAgent Byte 1 UC: Null=True Typ=Boolean Report as file available on Agent side
RH_FileInDB Byte 1 UC: Null=True Typ=Boolean Report in DB available
RH_UsersLogin Byte 1 UC: Null=True Typ=Boolean Require Users Login


Indexes:

Name Fields
NK_RH_AH_IDNR RH_AH_Idnr, RH_ArchiveFlag, RH_Type
NK_RH_Archive1 RH_DeleteFlag, RH_ArchiveFlag, RH_Client, RH_AH_Idnr, RH_Type
NK_RH_Archive2 RH_DeleteFlag, RH_AH_Idnr, RH_Type, RH_TimeStamp4, RH_ArchiveFlag
NK_RH_DelFlag RH_DeleteFlag, RH_Client, RH_AH_Idnr, RH_Type
NK_RH_Timestamp4 RH_AH_Idnr, RH_TimeStamp4
PK_RH RH_AH_Idnr, RH_Type
UK_RH_Typ RH_Client, RH_AH_Idnr, RH_Type


Return to the Index File