tm.report
Fields
| Field | Description |
|---|---|
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 |