Project Sub Tasks
Field Name |
Caption |
Mask |
Description |
Field Type |
JS_ACTCOST |
Actual Cost To Date |
nnnnnnnn.nn |
Actual Cost To Date |
Double |
JS_COM_PCT |
Completed Pct |
nnn.nn |
Completed Percentage |
Double |
JS_CRT_BY |
Created By |
25x |
Created By |
Text |
JS_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
JS_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
JS_ESTCOST |
Est Cost |
nnnnnnnn.nn |
Estimated Cost |
Double |
JS_ID |
Proj Sub Task Rec # |
nnnnnnnn |
SubTask Rec # |
Long Integer |
JS_JT_ID |
Proj Task Rec # |
nnnnnnnn |
Long Integer |
|
JS_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
JS_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
JS_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
JS_NUM |
Subtask ID |
20x |
Sub Task ID |
Text |
JS_PACT_DT |
Task Act Compl Date |
mm/dd/yyyy |
Sub Task Actual Completion Date |
Date/Time |
JS_PACT_TM |
Task Act Compl Time |
hh:mm am |
Sub Task Actual Completion Time |
Date/Time |
JS_PCLS_DT |
|
|
Sub Task Close Date |
Date/Time |
JS_PCLS_TM |
|
|
Sub Task Close Time |
Date/Time |
JS_PEST_DT |
Task Est Compl Date |
mm/dd/yyyy |
Sub Task Estimated Completion Date |
Date/Time |
JS_PEST_TM |
Task Est Compl Time |
hh:mm am |
Sub Task Estimated Completion Time |
Date/Time |
JS_PST_DT |
Task Start Date |
mm/dd/yyyy |
Sub Task Start Date |
Date/Time |
JS_PST_TM |
Task Start Time |
hh:mm am |
Sub Task Start Time |
Date/Time |
JS_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
JS_TASK_CD |
Task |
20x |
Sub Task |
Text |
JS_TASK_TY |
Task Text |
75x |
Sub Task Text |
Text |