Fieldpine Logo Documentation Home  

Timeschedule PHYSICAL Table Structure

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

FieldNameDatatypeMeta InfoGnapDescription
tsidlong,req100/sA unique number allocated to this row
fdlidlong101/E
activesdtdate102/sDate/Time that the row can be considered for execution. Records will not be considered until this date is reached
activeedtdate103/sDate/Time after which this row should no longer be executed
onlylicidlong104/EA 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
dowmasklong105/E
timestartdate106/sTime (any date component is ignored) setting the earliest time this record can begin
timeenddate107/sTime (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.
timeintervallong108/E
lastrundtdate109/s
userdatalong110/E
tsbtypelong111/E
runcountlong112/E
poscommandchar 200113/sThe PosCommand to be executed

Indexing