dataset BXmlDaemonQueue

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 tXmlDaemonQueue

Description

List of XML objects in the daemon queue.
Objects are loaded from the XML daemon configuration input folder.
Files on the file system are deleted when the contents is loaded here.

field name	data type	mnd.	description
XmlDaemonQueue_ID	integer	yes	Record ID
DaemonQueueId	integer	no	Daemon Queue
XmlDaemonQueueFileName	character(1024)	no	Original file name of the loaded object, excluding folder information. (This file no longer exists.)
XmlDaemonQueueAct	character(20)	no	Action code (not to be confused with the activity code) read from the input XML. possible values: SAVE SAVESTORE STORE VALIDATE
XmlDaemonQueueXmlCyCode	character(20)	no	Company code read from the XML input.
XmlDaemonQueueXmlCrtDate	date	no	creation date
XmlDaemonQueueXmlCrtTime	integer	no	creation time
XmlDaemonQueueXmlClassName	character(32)	no	business component name
XmlDaemonQueueXmlVersion	character(32)	no	(unused)
XmlDaemonQueueXmlOrigin	character(50)	no	Originator code read from the XML input.
XmlDaemonQueueXmlFreeText	character(1024)	no	Comments read from the XML input.
XmlDaemonQueueReturnStatus	integer	no	(unused)
XmlDaemonQueueLOB	clob	no	Text
XmlDaemonQueueFileOwner	character(20)	no	File Owner
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

After an object in the XMLDaemonQueue table has been processed by the XML daemon, either correctly or incorrectly, this table will contain a record per database object that was found in the XML input.

field name	data type	mnd.	description
XmlDaemonQueue_ID	integer	yes	XML Daemon Queue
XmlDaemonQOSeq	integer	yes	Sequence
XmlDaemonQOPrimaryKey	character(80)	no	Value of primary key fields of the main table record of the created / updated database object. Key fields are chr(2) separated.
XmlDaemonQOReturnStatus	integer	no	Result of processing this database object. Status < 0 when processing failed. Status >= 0 when processing succeeded.
XmlDaemonQORowid	character(20)	no	Rowid of the main table record of the created / updated database object.
XmlDaemonQODraftId	integer	no	Identification number of the draft instance created containing the data of the database object, in case action code indicated 'STORE'.
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	= tXmlDaemonQueue.tc_Rowid
tc_Status	character	no	update status

table tXmlDaemonQueueSegment

Description

XML object data is split up into 31K size segments

field name	data type	mnd.	description
XmlDaemonQueue_ID	integer	yes	XML Daemon Queue
XmlDaemonQueueSegmentSeq	integer	yes	Sequence
XmlDaemonQueueSegmentText	character	no	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	= tXmlDaemonQueue.tc_Rowid
tc_Status	character	no	update status

project BLF > class BXmlDaemonQueue > dataset BXmlDaemonQueue

object identification

table tfcDaemonQueue

Description

table tfcDaemonQueueLog

Description

table tCustomTable0

Description

table tCustomTable1

Description

table tCustomTable2

Description

table tXmlDaemonQueue

Description

table tXmlDaemonQueueObject

Description

table tXmlDaemonQueueSegment

Description