WKUTASK

Field Name

Caption

Mask

Description

Field Type

TK_AC_ID

Account Rec #

-nnnnnnnn

Link to WKACCTNO.AC_ID

Long Integer

TK_ACCTNO

Account #

45x

Account No.

Text

TK_ACT_FLG

Active Task

Active Task

Boolean

TK_AREA_CD

Area

10x

Area Code

Text

TK_AREA_TY

Area Text

40x

Area Description

Text

TK_CLASS

Class

40x

Class

Text

TK_CLASSCD

Classification

20x

Classification

Text

TK_CLASSTY

Classification Text

50x

Classification Text

Text

TK_COMP_NF

WO Complete Notif ID

nnnnnnnn

Link to CMNOTIF.NF_ID

Long Integer

TK_CON_CST

Est Contractor Cost

nnnnnn.nn

Est Contractor Cost

Double

TK_CREW_CD

Crew

10x

Crew Code

Text

TK_CREW_TY

Crew Text

25x

Crew Text

Text

TK_CRT_BY

Created By

25x

Created By

Text

TK_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

TK_DIV_CD

Division

10x

Division Code

Text

TK_DIV_TY

Division Text

40x

Division Description

Text

TK_DOC_FLG

Document Available

Doc Available: Doc Flag

Boolean

TK_DPT_CD

Department

10x

Department Code

Text

TK_DPT_TY

Department Text

50x

Department Description

Text

TK_DRWOR

Do not Reset WO Route

Do not Reset WO Route

Boolean

TK_DUR

Est Task Duration

nnn.nn

Task Duration

Double

TK_DUR_HRS

Est. Labor Hours

nnn.nn

Est. Duration (Hrs):

Double

TK_EA_ID

Eden Acct Rec #

nnnnnnnnn

Link to WKEACCTNO.EA_ID

Long Integer

TK_EMPL_CD

Lead Worker

20x

Employee Code

Text

TK_EMPL_TY

Lead Worker Text

40x

Employee Text

Text

TK_EP_ID

Eden Proj Rec #

nnnnnnnnn

Link to WKEPROJNO.EP_ID

Long Integer

TK_EQP_CST

Est Equipment Cost

nnnnnn.nn

Est Equipment Cost

Double

TK_FLUDCST

Est. Fluid Cost

nnnnnn.nn

Est. Fluid Cost:

Double

TK_GASB_CD

Valuation Adj

nnn

Valuation Adjustment

Integer

TK_GASB_TY

Valuation Adj Text

25x

Valuation Adjustment Text

Text

TK_ID

Task Rec #

nnnnnnnn

Unique ID

Long Integer

TK_IMG_FLG

Image Available

Boolean

TK_INCRM

Life Span Increase

nnn.nn

Life Span Increase

Double

TK_LAB_CST

Est. Labor Cost

nnnnnn.nn

Est. Labor Cost:

Double

TK_LCK_FLG

Lock UOM

Lock UOM for Task

Boolean

TK_LWOT_FLG

Update Asset Last WO Date

Update Asset Last WO Date

Boolean

TK_MACTN_CD

Meter Action

nnn

Meter Action

Integer

TK_MACTN_TY

Meter Action Text

25x

Meter Action Text

String

TK_MAT_CST

Est. Material Cost

nnnnnn.nn

Est. Material Cost:

Double

TK_MISCCST

Est. Misc. Cost

nnnnnn.nn

Est. Misc. Cost

Double

TK_MN_FLG

Main Task

Is Main Task

Boolean

TK_MOD_BY

Modified By

25x

Modified By

Text

TK_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified

Date/Time

TK_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

TK_MOV_FLG

Movie Available

Boolean

TK_OD_NF

Overdue Notif ID

nnnnnnnn

Link to CMNOTIF.NF_ID

Long Integer

TK_OID

Visual CE Linking Field

Long Integer

TK_PCLOCK

Projected Compl Lock

Projected Completion Lock

Boolean

TK_PM_FLG

PM Enable

Enable for PM/Routine popups

Boolean

TK_PNUMACT

Proj No - Acct

40x

Proj No - Acct

Text

TK_PRIO_NF

Priority Changed Notif ID

nnnnnnnn

Link to CMNOTIF.NF_ID

Long Integer

TK_PRIORCD

Priority

nnn

Priority

Integer

TK_PRIORTY

Priority Text

25x

Priority Text

Text

TK_PROJ

Project Task

Project Task

Boolean

TK_ROWVER

Rowversion for optimistic locking

Date/Time

TK_SAREACD

Sub-Area

10x

Sub-Area Code

Text

TK_SAREATY

Sub-Area Text

40x

Sub-Area Description

Text

TK_SDIV_CD

Sub-Division

10x

SubDivision Code

Text

TK_SDIV_TY

Sub-Division Text

40x

SubDivision Description

Text

TK_ST_FLG

Sub Task

Is Sub Task

Boolean

TK_STAT_CD

Task Status

nnn

Task Status

Integer

TK_STAT_NF

Link to WKNOTIF for WO Status Changed Notification

nnnnnnnn

Link to WKNOTIF for WO Status Changed Notification

Long Integer

TK_STAT_TY

Task Status Text

25x

Task Status Txt

Text

TK_STRT_NF

Start Date Notif ID

nnnnnnnn

Link to CMNOTIF.NF_ID

Long Integer

TK_SUPV_CD

Supervisor

20x

Supervisor Code

Text

TK_SUPV_TY

Supervisor Text

40x

Supervisor Text

Text

TK_TASK_CD

Task

20x

Task Code

Text

TK_TASK_TY

Task Text

75x

Task Text

Text

TK_TCSTEST

Est. Totat Cost

nnnnnnn.nn

Est. Total Cost:

Double

TK_TM_FLG

Timesheet Enable

Is Timesheet Task

Boolean

TK_TS_FLG

Daily Wrk Enable

Enable for PM/Routine popups

Boolean

TK_UNIT_C

Unit Cost

nnnnnn.nn

Unit Cost

Double

TK_UNIT_M

Units of Material

10x

Unit of Measure

Text

TK_UOM_CD

Unit of Measure

5x

Unit of Measure

Text

TK_UOM_TY

Unit of Measure Text

25x

Unit of Measure Text

Text

TK_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

TK_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

TK_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

TK_USER13

User 13

User 13

Boolean

TK_USER14

User 14

User 14

Boolean

TK_USER15

User 15

User 15

Boolean

TK_USER1CD

User 1

nnn

User 1

Integer

TK_USER1TY

User 1 Text

25x

User 1 Text

Text

TK_USER2CD

User 2

nnn

User 2

Integer

TK_USER2TY

User 2 Text

25x

User 2 Text

Text

TK_USER3CD

User 3

nnn

User 3

Integer

TK_USER3TY

User 3 Text

25x

User 3 Text

Text

TK_USER4

User 4

30x

User 4

Text

TK_USER5

User 5

30x

User 5

Text

TK_USER6

User 6

30x

User 6

Text

TK_USER7

User 7

-nnnnnnnn.nn

User 7

Double

TK_USER8

User 8

-nnnnnnnn.nn

User 8

Double

TK_USER9

User 9

-nnnnnnnn.nn

User 9

Double

TK_WO_FLG

WO Enable

Enable for Workorder popups

Boolean