Table reports

Table reports holds the table, page and display details for the reports/forms displayed in PhreeBooks. A single report will contain one field in table reports and several in report_fields.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
description varchar(30)   This is a brief description of the report. It is used as the report title for reports and is the default filename if the report is exported or imported.
narrative varchar(255)   This is a textual description used to provide details of the report or form. Information such as language, page setup, paper size, report purpose may be part of this field.
reporttype char(3)   Two possible types are frm (form) and rpt (report).
groupname varchar(9)   Indicates the group the report or form is a part of. Group names are defined in the reportwriter language file. Reports contain a single code to indicate the type whereas forms contain a two string code to indicate the type and usage. For reports and forms, the first value determines which tab the report appears in and for forms, the second code determines which folder in the tab the form appears in.
standard_report 0, 1   Indicates if the report is a standard report or has been customized by a user. Standard reports can only be customized through the report builder tool whereas custom reports can be saved by users after special cusotmization to meet his or her needs through the report display script.
special_report varchar(32)   REPORTS ONLY. When a report can not be generated with the standard reportwriter structure, a special report may be used to generated the fields displayed in the reports. A special class must be declared here (field contains the class name) to be included and executed to help reportwriter pull the correct information. The Balance Sheet and Income Statement report are examples of reports that require the special_report field.
table1 varchar(25)   The first database table used to pull information. REQUIRED
table2 varchar(25)   The second database table used to pull infomraiton. OPTIONAL but if present, must be accompanied with a criteria linking the tow tables.
table2criteria varchar(75)   Criteria used to link table1 to table2. OPTIONAL
table3 varchar(25)   The third database table. OPTIONAL
table3criteria varchar(75)   Link to either the first or second database table. OPTIONAL
table4 varchar(25)   The fourth database table. OPTIONAL
table4criteria varchar(75)   Link to either the first, second or third database table. OPTIONAL
table5 varchar(25)   The fifth database table. OPTIONAL
table5criteria varchar(75)   Link to either the first, second, third or fourth database table. OPTIONAL
table6 varchar(25)   The sixth database table. OPTIONAL
table6criteria varchar(75)   Link to either the first, second, third, fourth or fifth database table. OPTIONAL