Home > Technical > Table Definitions > LASTCOUNTERS2

LASTCOUNTERS2

Used as control table to record the last code processed for certain tasks. Primarily used when extracting data for the accounts interface, ticketing and other similar EOD processes.

Column Type Description
STRTASK VARCHAR(20) The task being performed. The exact codes are specific to the programs which require them. For example, TICKETITEM tracks the last item looked at for generating tickets.
STRTRADECODE VARCHAR(10) The location for which the task was being performed.
TRADUNIT.strTradeCode 
LINTLASTCODE BIGINT The last code that was examined for the task. When the process has finished looking at the required records it will update this number to the last number examined. This gives a starting position next time the process is run.
 

Primary Key: STRTASK + STRTRADECODE

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