Home > Technical > Table Definitions > INCOMINGTRANS

INCOMINGTRANS

All transactions generated at POS are written to INCOMINGTRANS. TillIncoming.exe will then examine these records. See Sales From POS To Database.

Column Type Description
INTQUEUENUM INT A number indicating which queue should process this record. This is determined from TRADUNIT.intQueueNum. It allows multi-threaded processing of data and/or multiple instances of TillIncoming to process the data.
INTSTATUS INT When a new record is written this will be 0. When the record has been processed it will be assigned a number by the system.

IntStatus 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.

Intstatus 100 - all bad sales which have been marked as corrupt by the system.

INTTRANSCODE BIGINT A number assigned by the system. Generally a POS transaction will result in several INCOMINGTRANS records. All the records from the same POS transaction will have the same INTTRANSCODE.
INTLINENUM INT The line number within the POS transaction. The first record of each transaction is 0, the next line 1, and so on.
STRMESSAGE VARCHAR(2000) The actual content of the line from the POS transaction.
STRCLIENTGUID VARCHAR(38) The unique number that was originally assigned to the POS transaction. This is recorded to ensure we don't sent the same transaction twice.
DTMCREATED DATETIME The date the record was written.
DTMTRANSSENT DATETIME The date/time the record was written.
STRTRADECODE VARCHAR(10) The location where the POS resides.
TRADUNIT.strTradeCode 
STRTILLCODE VARCHAR(10) The POS which made this transaction.
TILL.strTillCode
 

Primary Key: INTSTATUS + INTQUEUENUM + INTTRANSCODE + INTLINENUM

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