Table RT

Definition of table: RT - report content

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

AE Database 12.0 (Step 013)

Name Type Len Attributes Description

RT_AH_Idnr Long Integer 4 UC: Null=False reference to RH/AH

RT_Type Text 4 UC: Null=False report type (reference to type UC_RTYP)

RT_Lnr Long Integer 4 UC: Null=False ascending number of the report text

RT_TimeStamp Date/Time 8 UC: Null=True timestamp

RT_MsgNr Long Integer 4 UC: Null=False MSGNR if this is a logging record

RT_Content Memo 0 UC: L=8000 Null=True memostype text if MSGNR is not present

RT_MsgInsert Text 50 UC: Null=True L=1024 MSG_Insert if this is a logging record

Name	Type	Len	Attributes	Description
RT_AH_Idnr	Long Integer	4	UC: Null=False	reference to RH/AH
RT_Type	Text	4	UC: Null=False	report type (reference to type UC_RTYP)
RT_Lnr	Long Integer	4	UC: Null=False	ascending number of the report text
RT_TimeStamp	Date/Time	8	UC: Null=True	timestamp
RT_MsgNr	Long Integer	4	UC: Null=False	MSGNR if this is a logging record
RT_Content	Memo	0	UC: L=8000 Null=True	memostype text if MSGNR is not present
RT_MsgInsert	Text	50	UC: Null=True L=1024	MSG_Insert if this is a logging record

Indexes:

Name Fields

PK_RT RT_AH_Idnr, RT_Type, RT_Lnr

Name	Fields
PK_RT	RT_AH_Idnr, RT_Type, RT_Lnr

Return to the Index File