dataset BEventDaemonQueue

class dataset

object identification

primary key
DaemonQueueId
object identity
DaemonQueueId

table tfcDaemonQueue

Description

Table containing all request for the daemons.

field name	data type	mnd.	description
DaemonQueueId	integer	yes	identifier
DaemonId	integer	yes	Daemon ID
DaemonQueueStatus	character(40)	yes	possible values: WAITING IN-PROCESS PROCESSED-OK PROCESSED-ERROR
	value list:		{&DAEMONQUEUESTATUSES}
DaemonQueueReqStartDate	date	no	the request will not be processed before this date and time
DaemonQueueReqStartTime	integer	no	the request will not be processed before this date and time
DaemonQueuePriority	integer	yes	defines the sequence of processing requests in a single loop (also see fcdaemon.DaemonNrOfRequestsInLoop)
DaemonQueueStartDate	date	no	actual start date and time of processing the request
DaemonQueueStartTime	integer	no	actual start date and time of processing the request
DaemonQueueEndDate	date	no	actual end date and time of processing the request
DaemonQueueEndTime	integer	no	actual end date and time of processing the request
DaemonQueueLog	character(4000)	no	Error Log of this Daemon Request
DaemonQueueLockedProcess	integer	no	process ID of the daemon process that is handling this request
DaemonQueueRef	character(60)	no	internal reference to identify the request (may contain non-displayable ID's)
DaemonQueueRefDescription	character(1024)	no	displayable reference for identifying the request
tcDaemonQueueReqStartTimeConv	character(8)	no	Converted Time field
tcDaemonQueueStartTimeConv	character(8)	no	Converted Time field
tcDaemonQueueEndTimeConv	character(8)	no	Converted Time field
tcDaemonQueueStartDateTime	character(30)	no
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tfcDaemonQueueLog

Description

keeps error messages for requests that did not process correctly (copy of the contents from tFcMessages)

field name	data type	mnd.	description
DaemonQueueLogId	integer	yes	identifier
DaemonQueueId	integer	yes	Daemon Queue
DaemonQueueLogRowid	character(20)	no	= tFcMessages.tcFcRowid
DaemonQueueLogFieldName	character(80)	no	= tFcMessages.tcFcFieldName
DaemonQueueLogFieldValue	character(1024)	no	= tFcMessages.tcFcFieldValue
DaemonQueueLog	character(4000)	no	Log of this Daemon Request
DaemonQueueLogMessage	character(2048)	no	= tFcMessages.tcFcMessage
DaemonQueueLogSeverity	integer	no	= tFcMessages.tiFcSeverity
DaemonQueueLogType	character(20)	no	= tFcMessages.tcFcType
DaemonQueueLogFieldLabel	character(80)	no	= tFcMessages.tcFcFieldLabel
DaemonQueueLogBusMethod	character	no	The error message business method (copy of tFcMessages.tcFcBusMethod)
DaemonQueueLogContext	character(2000)	no	The error message context (copy of tFcMessages.tcFcContext)
DaemonQueueLogExplanation	character(2000)	no	The error message explanation (copy of tFcMessages.tcFcExplanation)
DaemonQueueLogIdent	character(2000)	no	The error message identification (copy of tFcMessages.tcFcIdentification)
DaemonQueueLogNumber	character(20)	no	The error message number (copy of tFcMessages.tcFcMsgNumber)
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tfcDaemonQueue.tc_Rowid
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tEventDaemonQueue

Description

list of events to be published

field name	data type	mnd.	description
EventDaemonQueue_ID	integer	yes	Record ID
DaemonQueueId	integer	no	Daemon Queue
EventDestination_ID	integer	no	Event Destination
EventDaemonQueueLOB	clob	no	Text
BusComponent_ID	integer	yes	Business Component
EventDaemonQueueStatus	character(20)	no	Status
tcBusComponentCode	character(26)	yes
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tfcDaemonQueue.tc_Rowid
tc_Status	character	no	update status

table tEventDaemonQueueSegment

Description

event data (in XML format) is split up in 31K size segments

field name	data type	mnd.	description
EventDaemonQueue_ID	integer	yes	Event Daemon Queue
EventDaemonQueueSegmentSeq	integer	yes	Segment sequence
EventDaemonQueueSegmentTxt	character(4000)	no	Segment text
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tEventDaemonQueue.tc_Rowid
tc_Status	character	no	update status