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.