dataset BReportVariant

class dataset

object identification

primary key
RptRequest_ID
object identity
RptRequest_ID

table tRptRequest

Description

base table for both report requests and variants

field name	data type	mnd.	description
RptRequest_ID	integer	yes	Record ID
RptPrinter_ID	integer	no	Printer
Lng_ID	integer	no	Language
RptRequestSchedule_ID	integer	no	Report Schedule
BusActivity_ID	integer	no	Business Activity
Usr_ID	integer	no	User
RptRequestName	character(40)	yes	Name
RptRequestDescription	character(255)	no	Description
RptRequestType	character(1)	no	possible values: R (request) V (variant)
RptRequestRptFileName	character(80)	no	The name of the rpt file that should be used for the execution of the report. This rpt file should be available on the client, in the Reports folder.
RptRequestRemoteLogic	logical	no	This indicates whether the business logic for the report needs to be run on the central application server, or in the report daemon process itself. By default, this should be true.
RptRequestNeedsCBF	logical	no	Indication if the report needs to use custom business fields.
RptRequestDateFormat	character(3)	no	possible values: dmy mdy ymd
	value list:		chr(2) + chr(2) + "dmy":U + chr(2) + "dmy":U + chr(2) + "mdy":U + chr(2) + "mdy":U + chr(2) + "ymd":U + chr(2) + "ymd":U
RptRequestDateSeparator	character(1)	no	possible values: . / -
	value list:		chr(2) + chr(2) + ".":U + chr(2) + ".":U + chr(2) + "/":U + chr(2) + "/":U + chr(2) + "-":U + chr(2) + "-":U
RptRequestTimeFormat	character(12)	no	possible values: hms hm
	value list:		"hms":U + chr(2) + "hms":U + chr(2) + "hm":U + chr(2) + "hm":U
RptRequestTimeSeparator	character(1)	no	possible values: : .
	value list:		":":U + chr(2) + ":":U + chr(2) + ".":U + chr(2) + ".":U
RptRequestDecimalPoint	character(1)	no	possible values: , .
	value list:		chr(2) + chr(2) + ",":U + chr(2) + ",":U + chr(2) + ".":U + chr(2) + ".":U
RptRequestTCDecimals	integer	no	comma separated list of currencies and their decimals to display or print
RptRequestFilterPrintMode	integer	no	How to print filter criteria on the report. possible values: 0 (do not print) 2 (print on first page) 3 (print on last page)
	value list:		{&FILTERPRINTMODES}
RptRequestPagebreakMode	logical	no	This indicates whether a page break needs to be added for each new break group level.
RptRequestUseAltShading	logical	no	Indication whether the report output needs to have alternate shading on the lines in the report.
RptRequestSaveFolder	character(255)	no	The name of the folder on the report server machine (best is UNC notation).
RptRequestSaveFileName	character(80)	yes	The name of the file that needs to be saved for the result of the report execution.
RptRequestMailSubject	character(255)	no	The text that need to be in the subject of the mail to be sent.
RptRequestMailBody	character(255)	no	The text that need to be in the body of the mail to be sent.
RptRequestMailTo	character(255)	no	Comma separated list of mail addresses to which the result needs to be sent (as TO) in a mail attachment.
RptRequestMailCC	character(255)	no	Comma separated list of mail addresses to which the result needs to be sent (as CC) in a mail attachment.
RptRequestMailBCC	character(255)	no	Comma separated list of mail addresses to which the result needs to be sent (as BCC) in a mail attachment.
RptRequestOutputFormat	character(3)	no	Type of document to create when writing the report output to the file system. possible values: DOC PDF RPT RTF XLS
	value list:		'' + chr(2) + '' + chr(2) + 'DOC' + chr(2) + 'DOC' + chr(2) + 'PDF' + chr(2) + 'PDF' + chr(2) + 'RPT' + chr(2) + 'RPT' + chr(2) + 'RTF' + chr(2) + 'RTF' + chr(2) + 'XLS' + chr(2) + 'XLS'
tcRptPrinterName	character(80)	no
tcLngCode	character(2)	no
tcBusActivityCode	character(40)	no
tcBusComponentCode	character(26)	no
tcUsrLogin	character(20)	no
ttRequestRequiredStartDate	date	no
tiRequestRequiredStartTime	integer	no
tcRequestStatus	character	no
ttRequestStartDate	date	no
tiRequestStartTime	integer	no
ttRequestEndDate	date	no
tiRequestEndTime	integer	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 tRptRequestCBF

Description

This table contains information about the custom business fields that need to be used on the report.

field name	data type	mnd.	description
RptRequestCBF_ID	integer	yes	Record ID
RptRequest_ID	integer	no	Report Request
RptRequestResultField	character(40)	no	This field contains the name of the field in the report result table, in the format "<result table name>.<fieldname>", where "<fieldname>" is always in the format "t<d>Custom<number>" (<d>=data type indication). For example: "tqDebtorAccountState.tcCustom1".
RptRequestCBF	character(40)	no	The name of the custom business field that is used to fill in the value in the related field in the result set. This is always in the format "<class-table-name>.<custom-field>". For example: "tDInvoice.CustomShort0".
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	= tRptRequest.tc_Rowid
tc_Status	character	no	update status

table tRptRequestFilter

Description

This table contains the filter values to pass to the report business logic when running the report. Data will be passed in the tFilter dataset parameter of the report method.

field name	data type	mnd.	description
RptRequestFilter_ID	integer	yes	Record ID
RptRequest_ID	integer	no	Report Request
RptRequestFilterBusField	character(40)	no	Business field name of the filter field.
RptRequestFilterSequence	integer	no	The sequence of the filter field, as it is shown on the report prompt page. (only used for variants)
RptRequestFilterOperator	character(8)	no	The name of the operator that needs to be used in the condition that is specified for the corresponding filter business field. Default "=".
RptRequestFilterIniValue1	character	no	The value that is used in the logic for the corresponding filter business field. If the operator is a range, then this is the "from" value.
RptRequestFilterIniValue2	character	no	(only valid for range operator) The value that is used in the logic for the corresponding filter business field; this is the "to" value.
RptRequestFilterIsRange	logical	no	Indication if the filter field is representing a range.
RptRequestFilterIsMand	logical	no	Indication if for this filter business field a value is required to be able to run the report. Default False.
RptRequestFilterIsVisible	logical	no	Indication if the filter field is visible when opening the report prompt-page.
RptRequestFilterDataType	character(1)	no	possible values: c (character) d (decimal) i (integer) l (logical) t (date)
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	= tRptRequest.tc_Rowid
tc_Status	character	no	update status

table tRptRequestMail

Description

When sending mail to a role, a mail is sent to all users in that role.

field name	data type	mnd.	description
RptRequestMail_ID	integer	yes	Record ID
RptRequest_ID	integer	no	Report Request
Role_ID	integer	no	Role
RptRequestMailType	character(3)	no	possible values: TO CC BCC
	value list:		'TO' + chr(2) + 'TO' + chr(2) + 'CC' + chr(2) + 'CC' + chr(2) + 'BCC' + chr(2) + 'BCC'
tcRoleName	character(20)	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	yes	= tRptRequest.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 tRptRequestVariant

field name	data type	mnd.	description
RptRequestVariant_ID	integer	yes	Record ID
Usr_ID	integer	no	User
Company_ID	integer	no	Entity
Role_ID	integer	no	Role
RptRequest_ID	integer	no	Report Request
tcUsrLogin	character(20)	no
tcCompanyCode	character(20)	no
tcRoleName	character(20)	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	yes	= tRptRequest.tc_Rowid
tc_Status	character	no	update status