TKLRACTION

This table holds the actions that can be performed on to-do items.

Column Descriptions:

NameTypeDescription
TKLRACTION_IDINTEGER NOT NULLGenerated unique key.
STORE_IDINTEGER NOT NULLStore for which this action is valid. Stores may establish their own tickler actions.
CODECHAR (30) NOT NULLCode used to reference the tickler action.
CLOSINGACTIONSMALLINT NOT NULL DEFAULT 0Whether action resolves the issue and hence should close the tickler after this action is recorded. Valid values are as follows:
  • 0 = this action will not close the tickler
  • 1 = this action will close the tickler
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this tickler reason has been marked for deletion:
  • 0 = No.
  • 1 = Yes, this tickler reason has been marked for deletion.
FIELD1VARCHAR (254)Customizable
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TKLRACTION_IDPrimary Key
I0000937CODE+STORE_IDUnique Index
I0000947STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1206STORE_IDSTORESTORE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1203TKLRACTION_IDTKLACTHISTTKLRACTION_IDCascade
F_1205TKLRACTION_IDTKLRACTDSCTKLRACTION_IDCascade