Statuses and Logs for Actions in Electronic Communication

Table Name: ECM3

Table Description: Statuses and Logs for Actions in Electronic Communication

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal ID	Int	11	ECM2
LogNum	Log Number	Int	11	-
LogType	Log Type	VarChar	1	-	R	S	Send
						R	Receive
						I	Import
						N	Note
						W	Warning
						E	Error
						D	WS Data
						B	Authorities Process Starts
						F	Authorities Process Finished
LogMessage	Log Message	Text	16	-
LogData	Log Data	Text	16	-
LogOpDate	Log Operation Date	Date	8	-
LogOpTS	Log Operation Time - Incl. Secs	Int	11	-
ExportFmt	Export Format	Int	11	OLLF
UserSign	User Signature	Int	6	OUSR
CreateDate	Creation Date	Date	8	-
CreateTS	Create Time - Incl. Secs	Int	11	-
UserSign2	Updating User	Int	6	OUSR
UpdateDate	Update Date	Date	8	-
UpdateTS	Update Time - Incl. Secs	Int	11	-
LogInstanc	Log Instance	Int	6	-
ExportFile	Export File	Text	16	-
AutProcess	Authorities Process	VarChar	1	-			None
						A	Approval Process
						R	Rejection Process
Sensitive	Log is Sensitive	VarChar	1	-	N	Y	Yes
						N	No