Master Project Email Tracking Table
Field Name |
Caption |
Mask |
Description |
Field Type |
TH_BTNUM |
Transfer Budget From |
20x |
Master Project where budget is requested to be transfered from |
Text |
TH_BY |
By |
25x |
Tracked User |
Text |
TH_CRT_BY |
Created By |
25x |
Created By |
Text |
TH_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TH_DESC |
Description |
999x |
Tracked Description |
Text |
TH_DT |
Date |
mm/dd/yyyy |
Tracked Date |
Date/Time |
TH_EMAIL_ID |
Link to Email Queue |
nnnnnnnn |
Link to the GBAUser.EMAILQUEUE |
Long Integer |
TH_ID |
Tracking Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
TH_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
TH_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TH_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TH_MP_ID |
Master Project ID |
-nnnnnnnn |
Long Integer |
|
TH_NEWPROJ |
New Sub Projects |
30x |
List of Sub Project Users want to add |
Text |
TH_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TH_TAMOUNT |
Transfer Amount |
-nnnnnnnnn.nn |
The amount of money that is requested to be transfered into this account |
Double |
TH_TM |
Time |
hh:mm am |
Tracked Time |
Date/Time |
TH_TRACK |
Tracked Item |
999x |
Tracked Item |
Text |