Home > Technical > Data > IncomingTrans

IncomingTrans

This table contains the raw transaction data sent from POS. A transaction from POS will consist of several lines in a text file. Each line of the text file is written to one record.

See Sales From POS To Database for more details on how this table is used.

Once the intStatus of an INCOMINGTRANS record is changed to 1, the record has been processed and it can actually be deleted. Otherwise the records will simply continue to grow.

intQueueNum

The queue to which the POS location belongs. By default this will be zero. However, you can define multiple queues and use threading to potentially improve performance. See Configuring Services for more details on how to use this number.  

intStatus

This indicates the status of the record and determines what processing needs to be done.

0

Not processed yet.

1

Processed successfully.

2

Processed with errors. Every hour the system will reset these records to a status of 0 in the hope that the cause of the error has been fixed and the records can be reprocessed.

4

Not processed but locked for stocktake. When the stocktake is unlocked, the status will be changed to 0 which will allow them to be processed.

5

Populating. Records are set to 5 until all records for the transaction has been inserted, then they are set to 0. This prevents only some of the transaction being processed.

intTransCode

A unique number assigned to the set of records which make up one transaction.

intLineNum

The line number of the record within a transaction. Starts from 1 and increments for each record.

strMessage

The actual content of the transaction.

strClientGUID

The unique GUID number that the POS sent with this transaction. We use this to determine if the POS has already sent the transaction or not.

dtmCreated

The date the record was created.

dtmTransSent

The date/time the record was written.

strTradeCode

The location of the POS that has sent the transaction.

strTillCode

The till code of the POS that has sent the transaction.

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