TICKLER

This table holds to-do items requiring actions to resolve.

Column Descriptions:

NameTypeDescription
TICKLER_IDBIGINT NOT NULLThe internal reference number of the to-do item.
STATUSSMALLINT NOT NULL DEFAULT 0Indicates the state of the tickler. Valid values are as follows:
  • 0=Tickler is in open state
  • 1=Tickler is in closed state
STORE_IDINTEGER NOT NULLThe identifier of the store in which this to-do item was created.
ACTIONOBJECTTYPECHAR (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
ACTIONOBJECTBIGINTID to referenced quote, order, return or customer.
TKLRREASON_IDINTEGER NOT NULLThe ID of codified reason for some to be tickled.
RESPONSIBLEMEMBERBIGINTIdentifier of the member who should act on this to-do item.
LOCKEDBY_IDBIGINTIdentifier of the member who locked this to-do item.
CREATEDBY_IDBIGINTIdentifier of the member who created this to-do item.
NEXTTICKLEDATETIMESTAMP NOT NULLWhen this to-do item should next pop into the tickler queue of the responsible member.
CREATETIMETIMESTAMP NOT NULLDate and time this to-do item was created.
LOCKTIMETIMESTAMPDate and time this to-do item was locked.
LASTUPDATETIMESTAMPDate and time this to-do item was last updated.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3BIGINTCustomizable.
LANGUAGE_IDINTEGER NOT NULLThe ID of the language used for the comment. For a list of language components, see the LANGUAGE table.
TICKLERCOMMENTVARCHAR (1024)Comments on this to-do item.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
RESPONSIBLEROLEINTEGERRole which should act on tickler. Either responsible member or role should be filled.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TICKLER_IDPrimary Key
I0000938STORE_IDNon-Unique Index
I0000939TKLRREASON_IDNon-Unique Index
I0000940LANGUAGE_IDNon-Unique Index
I0000941CREATEDBY_IDNon-Unique Index
I0000942LOCKEDBY_IDNon-Unique Index
I0000948 RESPONSIBLEMEMBER+STORE_ID+STATUS+NEXTTICKLEDATENon-Unique Index
I0000953RESPONSIBLEROLE+STORE_ID+STATUSNon-Unique Index
I0000954RESPONSIBLEROLENon-Unique Index
I0000978STATUS+NEXTTICKLEDATENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1194LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_1195LOCKEDBY_IDMEMBERMEMBER_IDCascade
F_1196CREATEDBY_IDMEMBERMEMBER_IDCascade
F_1197RESPONSIBLEMEMBERMEMBERMEMBER_IDCascade
F_1198STORE_IDSTORESTORE_IDCascade
F_1199TKLRREASON_IDTKLRREASONTKLRREASON_IDCascade
F_1217RESPONSIBLEROLEROLEROLE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1202TICKLER_IDTKLACTHISTTICKLER_IDCascade