Home > Technical > Table Definitions > REPORTS
A record is created for each report that is generated. These records are used by Merchant Report Manager to display the available reports to the user. The actual request for a report to be generated is stored in REPORTREQUEST.
Column | Type | Description |
DTMWHEN | DATETIME | The date/time the report was requested. |
STRFILENAME | VARCHAR(36) | The name of the file in which the report is stored. |
STRREPORTNAME | VARCHAR(100) | The name of the report. This is the user-friendly report name. |
STRCONTENTS | VARCHAR(100) | The contents of the report. This is usually a summary of the parameters below. |
STRWHO | VARCHAR(20) | The user
who requested the report.![]() |
STRSTATUS | VARCHAR(10) | The status of the report. New/Viewed/Printed |
STRPARAM1 | VARCHAR(15) | The 1st parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM2 | VARCHAR(15) | The 2nd parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM3 | VARCHAR(15) | The 3rd parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM4 | VARCHAR(15) | The 4th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM5 | VARCHAR(15) | The 5th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM6 | VARCHAR(15) | The 6th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM7 | VARCHAR(15) | The 7th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM8 | VARCHAR(15) | The 8th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM9 | VARCHAR(15) | The 9th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRORIENTATION | VARCHAR(10) | No longer used. |
MEMRECEIPIENT | VARCHAR(2000) | No longer used. |
STRTYPE | VARCHAR(10) | The type of report. This is usually the file extension of the report image. For POS BE reports, this will be either RAF or RAZ (a compressed RAF). |
INTSECURITY | INT | No longer used. |
MEMMESSAGE | VARCHAR(2000) | A description about the report. This can be printed |
strTradeCode | VARCHAR(10) | This is the
report location associated with the location to which the user
belongs. It is used to control access to reports. Any location with
the same report location will be able to view each other's
reports.![]() |
intSecurityGroup | INT | No longer used. |
strParam10 | VARCHAR(50) | The 10th parameter of the report. This will have controlled the generation of the data that appears on the report. |
strParam11 | VARCHAR(50) | The 11th parameter of the report. This will have controlled the generation of the data that appears on the report. |
strParam12 | VARCHAR(50) | The 12th parameter of the report. This will have controlled the generation of the data that appears on the report. |
strParam13 | VARCHAR(50) | The 13th parameter of the report. This will have controlled the generation of the data that appears on the report. |
strParam14 | VARCHAR(50) | The 14th parameter of the report. This will have controlled the generation of the data that appears on the report. |
strParam15 | VARCHAR(50) | The 15th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRORIGPROCESSID | VARCHAR(38) | If this report was requested from a report request program, this will be REPORTREQUEST.strProcessID. If the report as generated directly from the client program, for example a Goods Receipt report from the Goods Receipt function, this will be the internal name of the function, for example GOODSRECEIPT. |
STRPROCESSNAME | VARCHAR(40) | The internal process name that generated the report. |
STRPARAM16 | VARCHAR(15) | The 16th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM17 | VARCHAR(15) | The 17th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM18 | VARCHAR(15) | The 18th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM19 | VARCHAR(15) | The 19th parameter of the report. This will have controlled the generation of the data that appears on the report. |
STRPARAM20 | VARCHAR(15) | The 20th parameter of the report. This will have controlled the generation of the data that appears on the report. |
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |