TICKLER
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