Home > Technical > Table Definitions > REPORTREQUEST

REPORTREQUEST

Each report that is requested by a user will have a record in this table. The system will then process each REPORTREQUEST record and generate the actual report. For each actual report, the system will write a record to the REPORTS table.

Column Type Description
STRPROCESSID VARCHAR(38) A unique ID assigned by the system that identifies the report request.
STRPROCESSNAME VARCHAR(40) The internal name of the report.
STRWHO VARCHAR(20) The user who requested the report.
USERCODE.strUserCode 
DTMWHEN DATETIME The date/time of the request.
STRPARAM1 VARCHAR(30) The 1st parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM2 VARCHAR(30) The 2nd parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM3 VARCHAR(30) The 3rd parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM4 VARCHAR(30) The 4th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM5 VARCHAR(30) The 5th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM6 VARCHAR(30) The 6th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM7 VARCHAR(30) The 7th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM8 VARCHAR(30) The 8th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM9 VARCHAR(30) The 9th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM10 VARCHAR(30) The 10th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM11 VARCHAR(30) The 11th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM12 VARCHAR(30) The 12th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM13 VARCHAR(30) The 13th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM14 VARCHAR(30) The 14th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM15 VARCHAR(30) The 15th parameter of the report. This will control the generation of the data that appears on the report.
INTLOCALEID INT The Windows locale of the client requesting the report. This can be used to ensure that the correct date and money formats are used on a report.
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 

YSNREPLOCATIONPERGROUP VARCHAR(1) On some reports you can specify a group location and generate a separate report for each location within the group. If this field is 'T' the system will write the REPORTS.strTradeCode as the specific store location. This means you can request the report once and each generated report will be visible only at the store itself. If this is 'F' the REPORTS.strTradeCode will be the report location associated with the user's location. This means all of the individual reports for each store will only be visible at the user's location, not each store. The default value is 'F'.
INTSTATUS INT The current status of the request.
1   Requested
2   Processing
3   Finished successfully
4   Finished with error
STRPARAM16 VARCHAR(30) The 16th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM17 VARCHAR(30) The 17th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM18 VARCHAR(30) The 18th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM19 VARCHAR(30) The 19th parameter of the report. This will control the generation of the data that appears on the report.
STRPARAM20 VARCHAR(30) The 20th parameter of the report. This will control the generation of the data that appears on the report.
 

Primary Key: STRPROCESSID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)