This table holds the actions that can be performed
on to-do items.
Column Descriptions:
| Name | Type | Description |
| TKLRACTION_ID | INTEGER NOT NULL | Generated unique key. |
| STORE_ID | INTEGER NOT NULL | Store for which this action is valid. Stores may
establish their own tickler actions. |
| CODE | CHAR (30) NOT NULL | Code used to reference the tickler action. |
| CLOSINGACTION | SMALLINT NOT NULL DEFAULT 0 | Whether 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
|
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this tickler reason has been marked
for deletion:
- 0 = No.
- 1 = Yes, this tickler reason has been marked for deletion.
|
| FIELD1 | VARCHAR (254) | Customizable |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | TKLRACTION_ID | Primary Key |
| I0000937 | CODE+STORE_ID | Unique Index |
| I0000947 | STORE_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1206 | STORE_ID | STORE | STORE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1203 | TKLRACTION_ID | TKLACTHIST | TKLRACTION_ID | Cascade |
| F_1205 | TKLRACTION_ID | TKLRACTDSC | TKLRACTION_ID | Cascade |