Home > Technical > Table Definitions > INCOMINGTRANS
All transactions generated at POS are written to INCOMINGTRANS. TillIncoming.exe will then examine these records. See Sales From POS To Database.
|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.|
location where the POS resides.
which made this transaction.
Primary Key: INTSTATUS + INTQUEUENUM + INTTRANSCODE + INTLINENUM
|Converted from CHM to HTML with chm2web Pro 2.85 (unicode)|