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