Work PM Tracking Table
Field Name |
Caption |
Mask |
Description |
Field Type |
TC_BY |
Tracked By |
25x |
Tracked User |
Text |
TC_CRT_BY |
Created By |
25x |
Created By |
Text |
TC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TC_DESC |
Description |
999x |
Tracked Description |
Text |
TC_DT |
Tracked Date |
mm/dd/yyyy |
Tracked Date |
Date/Time |
TC_ID |
AutoNumber |
nnnnnnnn |
AutoNumber |
Long Integer |
TC_MOD_BY |
Modified By |
25x |
Last Modified By |
Text |
TC_MOD_DT |
Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TC_MOD_TM |
Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TC_REASON |
Tracked Reason |
999x |
Reason |
Text |
TC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TC_TM |
Tracked Time |
hh:mm am |
Tracked Time |
Date/Time |
TC_TO_ID |
Link To PM |
nnnnnnnn |
Long Integer |