This table holds to-do items requiring actions to resolve.
Column Description(s):
Column Name | Column Type | Description |
TICKLER_ID |
BIGINT NOT NULL |
The internal reference number of the to-do item. |
STATUS |
SMALLINT NOT NULL DEFAULT 0 |
Indicates the state of the tickler. Valid values are as follows:
- 0=Tickler is in open state
- 1=Tickler is in closed state
|
STORE_ID |
INTEGER NOT NULL |
The identifier of the store in which this to-do item was created. |
ACTIONOBJECTTYPE |
CHAR(5) |
The type of object to which this to-do item is associated. Valid values are as follows:
- ORDER=Order
- QUOTE=Quote
- RMA=Return
- USER=Customer
|
ACTIONOBJECT |
BIGINT |
ID to refenced quote, order, return or customer. |
TKLRREASON_ID |
INTEGER NOT NULL |
The ID of codified reason for some to be tickled. |
RESPONSIBLEMEMBER |
BIGINT |
Identifier of the member who should act on this to-do item. |
LOCKEDBY_ID |
BIGINT |
Identifier of the member who locked this to-do item. |
CREATEDBY_ID |
BIGINT |
Identifier of the member who created this to-do item. |
NEXTTICKLEDATE |
TIMESTAMP NOT NULL |
When this to-do item should next pop into the tickler queue of the responsible member. |
CREATETIME |
TIMESTAMP NOT NULL |
Date and time this to-do item was created. |
LOCKTIME |
TIMESTAMP |
Date and time this to-do item was locked. |
LASTUPDATE |
TIMESTAMP |
Date and time this to-do item was last updated. |
FIELD1 |
INTEGER |
Customizable. |
FIELD2 |
VARCHAR(254) |
Customizable. |
FIELD3 |
BIGINT |
Customizable. |
LANGUAGE_ID |
INTEGER NOT NULL |
The ID of the language used for the comment. For a list of language components, see the LANGUAGE table. |
TICKLERCOMMENT |
VARCHAR(1024) |
Comments on this to-do item. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
RESPONSIBLEROLE |
INTEGER |
Role which should act on tickler. Only responsible member or role should be filled; not both. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031321790 |
TICKLER_ID |
Primary Key |
I0000938 |
STORE_ID |
Non-Unique Index |
I0000939 |
TKLRREASON_ID |
Non-Unique Index |
I0000940 |
LANGUAGE_ID |
Non-Unique Index |
I0000941 |
CREATEDBY_ID |
Non-Unique Index |
I0000942 |
LOCKEDBY_ID |
Non-Unique Index |
I0000948 |
RESPONSIBLEMEMBER+STORE_ID+STATUS+NEXTTICKLEDATE |
Non-Unique Index |
I0000953 |
RESPONSIBLEROLE+STORE_ID+STATUS |
Non-Unique Index |
I0000954 |
RESPONSIBLEROLE |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1194 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
F_1195 |
LOCKEDBY_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_1196 |
CREATEDBY_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_1197 |
RESPONSIBLEMEMBER |
MEMBER |
MEMBER_ID |
Cascade |
F_1217 |
RESPONSIBLEROLE |
ROLE |
ROLE_ID |
Cascade |
F_1198 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
F_1199 |
TKLRREASON_ID |
TKLRREASON |
TKLRREASON_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1202 |
TICKLER_ID |
TKLACTHIST |
TICKLER_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.