WKCHKLSTWO

Work Order Check List

Field Name

Caption

Mask

Description

Field Type

LW_COMP_DT

Completion Date

mm/dd/yyyy

Completed Date

Date/Time

LW_COMP_TM

Completion Time

hh:mm am

Completed Time

Date/Time

LW_COMPL

Completed

 

Completed

Boolean

LW_COND_CD

Condition

nnn

Condition

Integer

LW_COND_TY

Condition Text

25x

Condition Text

Text

LW_CRT_BY

Created By

25x

Created By

Text

LW_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

LW_EST_DT

Est Completion Date

mm/dd/yyyy

Estimated Completion Date

Date/Time

LW_ID

Checklist Rec #

-nnnnnnnn

Autonumber ID

Long Integer

LW_INIDTTM

Initiated Date/Time

mm/dd/yyyy hh:mm am

Initiated Date/Time

Date/Time

LW_MOD_BY

Last Modified By

25x

Last Modified By

Text

LW_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

LW_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

LW_NOTE

Note

250x

Note

Text

LW_NUMBER

Line Number

nnnnnnnn

Line Number

Long Integer

LW_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

LW_TEXT

Checklist

100x

Checklist Instructions

Text

LW_USER10CD

User 10

20x

User 10

String

LW_USER10TY

User 10 Text

60x

User 10 Text

String

LW_USER11

User 11

100x

User 11

String

LW_USER12

User 12

100x

User 12

String

LW_USER13

User 13

100x

User 13

String

LW_USER14

User 14

100x

User 14

String

LW_USER15

User 15

100x

User 15

String

LW_USER16

User 16

nnnnnnnn.nn

User 16

Double

LW_USER17

User 17

nnnnnnnn.nn

User 17

Double

LW_USER18

User 18

nnnnnnnn.nn

User 18

Double

LW_USER19

User 19

nnnnnnnn.nn

User 19

Double

LW_USER1CD

User 1

nnn

User 1

integer

LW_USER1TY

User 1 Text

100x

User 1 Text

String

LW_USER20

User 20

nnnnnnnn.nn

User 20

Double

LW_USER21

User 21

mm/dd/yyyy hh:mm am

User 21

DateTime

LW_USER22

User 22

mm/dd/yyyy hh:mm am

User 22

DateTime

LW_USER23

User 23

mm/dd/yyyy hh:mm am

User 23

DateTime

LW_USER24

User 24

mm/dd/yyyy hh:mm am

User 24

DateTime

LW_USER25

User 25

mm/dd/yyyy hh:mm am

User 25

DateTime

LW_USER26

User 26

 

User 26

Boolean

LW_USER27

User 27

 

User 27

Boolean

LW_USER28

User 28

 

User 28

Boolean

LW_USER29

User 29

 

User 29

Boolean

LW_USER2CD

User 2

nnn

User 2

integer

LW_USER2TY

User 2 Text

100x

User 2 Text

String

LW_USER30

User 30

 

User 30

Boolean

LW_USER3CD

User 3

nnn

User 3

integer

LW_USER3TY

User 3 Text

100x

User 3 Text

String

LW_USER4CD

User 4

nnn

User 4

integer

LW_USER4TY

User 4 Text

100x

User 4 Text

String

LW_USER5CD

User 5

nnn

User 5

integer

LW_USER5TY

User 5 Text

100x

User 5 Text

String

LW_USER6CD

User 6

20x

User 6

String

LW_USER6TY

User 6 Text

60x

User 6 Text

String

LW_USER7CD

User 7

20x

User 7

String

LW_USER7TY

User 7 Text

60x

User 7 Text

String

LW_USER8CD

User 8

20x

User 8

String

LW_USER8TY

User 8 Text

60x

User 8 Text

String

LW_USER9CD

User 9

20x

User 9

String

LW_USER9TY

User 9 Text

60x

User 9 Text

String

LW_WO_ID

Work Order Rec #

-nnnnnnnn

Link to WKORDER.WO_ID

Long Integer