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 |