Home > Technical > Table Definitions > REPORTS

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.
USERCODE.strUserCode 
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.
TRADUNIT.strTradeCode 
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)