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_WO_ID |
Work Order Rec # |
-nnnnnnnn |
Long Integer |