Project Activity table
Field Name |
Caption |
Mask |
Description |
Field Type |
AP_ACT_CD |
Activity Type |
5x |
Activity Type |
String |
AP_ACT_TY |
Activity Type Text |
30x |
Activity Type Text |
String |
AP_ACT_DT |
Activity Date |
mm/dd/yyyy |
Activity Date |
Date/Time |
AP_ACTIVI |
Activity |
200x |
Activity |
Text |
AP_ASSGN_CD |
Assigned To |
20x |
Assigned To |
String |
AP_ASSGN_TY |
Assigned To Text |
40x |
Assigned To Text |
String |
AP_COMMENT1 |
Long Note |
|
Long Note |
Memo |
AP_CRT_BY |
Created By |
25x |
Created By |
Text |
AP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
AP_END_DT |
Activity Finish Date |
mm/dd/yyyy hh:mm am |
Activity Finish Date |
DateTime |
AP_ID |
Project Activity Rec # |
nnnnnnnn |
Project Activity Rec # |
Long Integer |
AP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
AP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
AP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AP_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
AP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |