Work Order Event Occurrences
Field Name |
Caption |
Mask |
Description |
Field Type |
WE_COMM |
|
|
Event Comment |
Text |
WE_CRT_BY |
Created By |
25x |
Created By |
Text |
WE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
WE_EVNT_CD |
Event |
nnn |
Event |
Integer |
WE_EVNT_DT |
Event Date |
mm/dd/yyyy |
Event Date |
Date/Time |
WE_EVNT_TM |
Event Time |
hh:mm am |
Event Time |
Date/Time |
WE_EVNT_TY |
Event Text |
25x |
Event Text |
Text |
WE_HANDHELD |
|
50x |
Handheld Name |
Text |
WE_ID |
Event Rec # |
-nnnnnnnn |
Unique ID |
Long Integer |
WE_INIDTTM |
Initiated Date/Time |
mm/dd/yyyy hh:mm am |
Initiated Date/Time |
Date/Time |
WE_MBL_ID |
|
|
Copy of WE_ID for mobile device |
Long Integer |
WE_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
WE_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
WE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
WE_NOTE |
Note |
200x |
Note |
Text |
WE_OID |
|
|
Visual CE Linking Field |
Long Integer |
WE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
WE_TIMESTAMP |
Mobile Timestamp |
mm/dd/yyyy |
Timestamp for Visual CE |
Date/Time |
WE_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |