Project Tasks
Field Name |
Caption |
Mask |
Description |
Field Type |
JT_AC_ID |
Account Record # |
nnnnnnnn |
Long Integer |
|
JT_ACCOUNT |
Account # |
45x |
Account # |
Text |
JT_ACTCOST |
Actual Cost To Date |
nnnnnnnn.nn |
Actual Cost To Date |
Double |
JT_CAT_CD |
Category |
10x |
Category |
Text |
JT_CAT_TY |
Category Text |
60x |
Category Text |
Text |
JT_CAUS_CD |
Cause |
10x |
Cause: |
Text |
JT_CAUS_TY |
Cause Text |
40x |
Cause Text: |
Text |
JT_COM_PCT |
Completed Pct |
nnn.nn |
Completed Percentage |
Double |
JT_CRT_BY |
Created By |
25x |
Created By |
Text |
JT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
JT_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
JT_EA_ID |
Eden Account Record # |
nnnnnnnn |
Long Integer |
|
JT_EMP_CD |
Lead Worker |
11x |
Assigned To |
Text |
JT_EMP_TY |
Lead Worker Text |
40x |
Assigned To Text |
Text |
JT_EP_ID |
Eden Project Record # |
nnnnnnnn |
Long Integer |
|
JT_ESTCOST |
Est Cost |
nnnnnnnn.nn |
Estimated Cost |
Double |
JT_ID |
Project Task Rec # |
nnnnnnnn |
Project Rec # |
Long Integer |
JT_INV_ID |
|
|
Link to WKCATINV.CI_ID - Lucity System Category |
Long Integer |
JT_MILE_CD |
Milestone |
nnn |
Milestone |
Integer |
JT_MILE_TY |
Milestone Text |
25x |
Milestone Text |
Text |
JT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
JT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
JT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
JT_MP_ID |
Master Project Rec # |
nnnnnnnn |
Long Integer |
|
JT_NUM |
Task ID |
20x |
Project ID |
Text |
JT_PACT_DT |
Task Act Compl Date |
mm/dd/yyyy |
Task Actual Completion Date |
Date/Time |
JT_PACT_TM |
Task Act Compl Time |
hh:mm am |
Task Actual Completion Time |
Date/Time |
JT_PCLS_DT |
|
|
Task Close Date |
Date/Time |
JT_PCLS_TM |
|
|
Task Close Time |
Date/Time |
JT_PEST_DT |
Task Est Compl Date |
mm/dd/yyyy |
Task Estimated Completion Date |
Date/Time |
JT_PEST_TM |
Task Est Compl Time |
hh:mm am |
Task Estimated Completion Time |
Date/Time |
JT_PJ_ID |
Project Rec # |
nnnnnnnn |
Long Integer |
|
JT_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
JT_PROB_CD |
Problem |
10x |
Problem: |
Text |
JT_PROB_TY |
Problem Text |
40x |
Problem Text: |
Text |
JT_PST_DT |
Task Start Date |
mm/dd/yyyy |
Task Start Date |
Date/Time |
JT_PST_TM |
Task Start Time |
hh:mm am |
Task Start Time |
Date/Time |
JT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
JT_STAT_CD |
Status |
nnn |
Status |
Integer |
JT_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
JT_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
JT_STAT_TY |
Status Text |
25x |
Status Text |
Text |
JT_SUPR_CD |
Supervisor |
11x |
Supervisor: |
Text |
JT_SUPR_TY |
Supervisor Text |
40x |
Supervisor Text: |
Text |
JT_TASK_CD |
Task |
20x |
Main Task |
Text |
JT_TASK_TY |
Task Text |
75x |
Main Task Text |
Text |