Storm Water Quality Commercial Email Tracking
Field Name |
Caption |
Mask |
Description |
Field Type |
KT_BY |
Tracked User |
25x |
Tracked User |
String |
KT_CRT_BY |
Created By |
25x |
Created By |
String |
KT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
KT_DESC |
Tracked Description |
125x |
Tracked Description |
String |
KT_DT |
Tracked Date |
mm/dd/yyyy hh:mm am |
Tracked Date |
DateTime |
KT_EMAIL_ID |
Link to the EMAILQUEUE |
nnnnnnnn |
Link to the EMAILQUEUE.EMAIL_ID |
Long Integer |
KT_ID |
Commercial Tracking Rec #: Unique ID |
nnnnnnnn |
Commercial Tracking Rec #: Unique ID |
Long Integer |
KT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
KT_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
KT_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
KT_QC_ID |
Commercial Record No |
nnnnnnnn |
Long Integer |
|
KT_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
KT_TM |
Tracked Time |
mm/dd/yyyy hh:mm am |
Tracked Time |
DateTime |
KT_TRACK |
Tracked Item |
125x |
Tracked Item |
String |