This page contains technical detail about the physical database structure. It is not required
for day to day operation of the Point Of Sale.
Overview
Contains a list of business transactions received for processing. A business transaction is a high level operation performed by the POS, such as "create a sale", "edit a customer", "redeem a voucher".
Columns
| FieldName | Datatype | Meta Info | Description |
| MessageId | String | Typically 32 bytes | A unique reference code for this record |
| Type | String | A keyword name for this transaction. Eg. "ProductEdit" | |
| Received | Date/Time | Date/Time this transaction was received on the server. | |
| DiscardLife | Number | Number of seconds after which the generator has said this transaction can be discarded | |
| SourceMAC | String | ||
| PacketType | Number | ||
| Schema | Number | ||
| SourceIP | String | The dotted IP address this packet was received from. Depending on network configuration and how packets flowed through the network this may not be the generating nodes IP address | |
| Urgency | Number | ||
| Importance | Number | ||
| OnlineFlag | Number | ||
| Size | Number | Size of transaction data packet in bytes |
Indexing
- TBA.