EFEQUIP tracking table
Field Name |
Caption |
Mask |
Description |
Field Type |
EN_BY |
By |
25x |
Tracked User |
Text |
EN_CRT_BY |
Created By |
25x |
Created By |
Text |
EN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EN_DESC |
Description |
80x |
Tracked Description |
Text |
EN_DT |
Date |
mm/dd/yyyy |
Tracked Date |
Date/Time |
EN_EMAIL_ID |
Link to Email Queue |
nnnnnnnnn |
Link to the GBAUser.EMAILQUEUE table |
Long Integer |
EN_GE_ID |
Equipment Rec # |
-nnnnnnnn |
Long Integer |
|
EN_ID |
Notification Track Rec # |
nnnnnnnn |
Equipment Email Notification Track Rec # |
Long Integer |
EN_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
EN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
EN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
EN_TM |
Time |
hh:mm am |
Tracked Time |
Date/Time |
EN_TRACK |
Tracked Item |
125x |
Tracked Item |
Text |