WKRTTSK

Field Name

Caption

Mask

Description

Field Type

TT_AC_ID

Account Rec #

nnnnnnnn

Link To WKACCTNO.AC_ID

Long Integer

TT_ACCOUNT

Account #

45x

Account #

Text

TT_CLASS

Class

40x

Class

Text

TT_CONEST

Est Contractor Cost

nnnnnnnn.nn

Estimated Contractor Cost

Double

TT_CREW_CD

Task Crew

10x

Crew

Text

TT_CREW_TY

Task Crew Text

25x

Crew Text

Text

TT_CREWRS

Crew Supervisor

Boolean

TT_CRT_BY

Created By

25x

Created By

Text

TT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

TT_DOC_FLG

Document Available

Doc Available: Doc Flag

Boolean

TT_EA_ID

Eden Account Rec #

nnnnnnnn

Link to WKEACCTNO.EA_ID

Long Integer

TT_END_DT

Task End Date

mm/dd/yyyy

End Date

Date/Time

TT_END_TM

Task End Time

hh:mm am

End Time

Date/Time

TT_EP_ID

Eden Project Rec #

nnnnnnnn

Link to WKEPROJNO.EP_ID

Long Integer

TT_EQ_EST

Est Equipment Cost

nnnnn.nn

Est Equipment Cost

Double

TT_FLUDEST

Est. Fluid Cost

nnnnnnnn.nn

Estimated Fluid Cost

Double

TT_ID

Task Rec #

nnnnnnnn

Unique ID

Long Integer

TT_IMG_FLG

Image Available

Boolean

TT_LC_EST

Est Labor Cost

nnnnn.nn

Est Labor Cost

Double

TT_LH_EST

Est Labor Hours

nnnn.nn

Est Labor Hours

Double

TT_LOCNO

Seq No

nnn

Sequence Number

Integer

TT_MAT_EST

Est Material Cost

nnnnn.nn

Est Material Cost

Double

TT_MISCEST

Est Misc Cost

nnnnnnnn.nn

Estimated Misc. Cost

Double

TT_MOD_BY

Last Modified By

25x

Modified By :

Text

TT_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified :

Date/Time

TT_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

TT_MOV_FLG

Movie Available

Boolean

TT_PNUMACT

Proj No - Acct

40x

Proj No - Acct

Text

TT_RES_EST

Use Est Res Cost

Use Est Resource Cost?

Boolean

TT_ROWVER

Rowversion for optimistic locking

Date/Time

TT_STRT_DT

Task Start Date

mm/dd/yyyy

Start Date

Date/Time

TT_STRT_TM

Task Start Time

hh:mm am

Start Time

Date/Time

TT_SUPR_CD

Task Supervisor

20x

Supervisor

Text

TT_SUPR_TY

Task Supervisor Text

40x

Supervisor Text

Text

TT_TASK_CD

Task

20x

Task

Text

TT_TASK_TY

Task Text

75x

Task Text

Text

TT_TC_EST

Est Total Cost

nnnnnn.nn

Est Total Cost

Double

TT_TO_ID

Link To PM

nnnnnnnn

Link to WKROUTINE.TO_ID

Long Integer

TT_TOTCOST

Total Cost

nnnnnnn.nn

Total Cost

Double

TT_UNIT_C

Unit Cost

nnnnn.nnn

Unit Cost

Double

TT_UNIT_M

Units of Measure

10x

Unit of Measure

Text

TT_UNITS

# of Units

nnnnn.nn

Units

Double

TT_UOM_CD

Unit of Measure

5x

Unit of Measure

Text

TT_UOM_TY

Unit of Measure Text

25x

Unit of Measure Text

Text

TT_USER1CD

Task User 1

nnn

User 1

Integer

TT_USER1TY

Task User 1 Text

25x

User 1 Text

Text

TT_USER2

Task User 2

-nnnnnnnn.nn

User 2

Double