This page contains technical detail about the physical database structure. It is not required for normal day to day operation of the Point Of Sale.
Overview
This table holds actions to be performed at specific times if the POS is able to.
Mesh
Pending
Columns
FieldName | Datatype | Meta Info | Gnap | Description |
tsid | long,req | 100/s | A unique number allocated to this row | |
fdlid | long | 101/E | ||
activesdt | date | 102/s | Date/Time that the row can be considered for execution. Records will not be considered until this date is reached | |
activeedt | date | 103/s | Date/Time after which this row should no longer be executed | |
onlylicid | long | 104/E | A licid number to force this action to only be executed on a specific system. A value of zero means all lanes should execute this command | |
dowmask | long | 105/E | ||
timestart | date | 106/s | Time (any date component is ignored) setting the earliest time this record can begin | |
timeend | date | 107/s | Time (date component ignored) setting the last time at which this job can begin. This does not stop jobs at this time, jobs are free to run for as long as they require. | |
timeinterval | long | 108/E | ||
lastrundt | date | 109/s | ||
userdata | long | 110/E | ||
tsbtype | long | 111/E | ||
runcount | long | 112/E | ||
poscommand | char 200 | 113/s | The PosCommand to be executed |