tm.report

list of defined reports fields field type description id int unique id name mlstring name of the report description 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\ string] the actual report definition, see reports docid 8utanginlcjpbeqb5fmyg 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 http //en wikipedia org/wiki/gettext 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