This table holds to-do items requiring actions to
resolve.
Column Descriptions:
| Name | 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 referenced 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| RESPONSIBLEROLE | INTEGER | Role which should act on tickler. Either
responsible member or role should be filled. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | 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 |
| I0000978 | STATUS+NEXTTICKLEDATE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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_1198 | STORE_ID | STORE | STORE_ID | Cascade |
| F_1199 | TKLRREASON_ID | TKLRREASON | TKLRREASON_ID | Cascade |
| F_1217 | RESPONSIBLEROLE | ROLE | ROLE_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1202 | TICKLER_ID | TKLACTHIST | TICKLER_ID | Cascade |