tm.report

List of defined reports

Fields

FieldDescription
id
int
Unique ID
name<langcode>
mlstring
Name of the report
description<langcode>
mlstring
Description of the report
reporttypeid
int
The report type defines the UI and parameters that are used when generating the report
defaultformat
string
Reports can be generated as pdf or excel file. This field defines the default format. Possible values are ‘pdf’ or ‘excel’
content
[[map[k:string t:map v:mixed]]]
The actual report definition, see reports for more information.
subtitles
[string]
A list of subtitles for the report
options
ReportOptions
Key-value array of options. Can contain: pdfpagesize, excelpagewidth, excelscaling, usesystemfont
translations
map[k:string t:map v:string]
A map of language codes to gettext .po files.
emailschedule
bool
Indicates if this report is scheduled to be sent by mail at a certain interval
emailschedulehourofday
int
Hour of the day the report will be sent
emailscheduledayofweek
int
Day of the week the report will be sent. 1 = monday -> 7 = sunday
emailscheduledayofmonth
int
Day of the month the report will be sent.
emailschedulequery
string
Report will only be sent if the given query returns at least one result.
emailrecipients
string
List of email recipients that should receive the report, separated by ;
emailcc
string
List of email recipients that should receive the report in cc, separated by ;
emailbcc
string
List of email recipients that should receive the report in bcc, separated by ;
usagetypeid
int
Indicates where the report is being used. Possible values: 17001 (Sales), 17002 (External sales), 17003 (Hidden)
createdts
timestamp
Created timestamp
lastupdatets
timestamp
Last updated timestamp