LINKING TASKS TO ASSETS ON WORK ORDERS
Field Name |
Caption |
Mask |
Description |
Field Type |
KT_AS_ID |
Asset |
nnnnnnnn |
Long Integer |
|
KT_CRT_BY |
Created By |
25x |
Created By |
Text |
KT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
KT_ID |
AutoNumber |
-nnnnnnnn |
Autonumber |
Long Integer |
KT_INIDTTM |
|
|
Date/Time created. Used to manage field updates |
Date/Time |
KT_MOD_BY |
Last Modified By |
25x |
modified by |
Text |
KT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
modified date |
Date/Time |
KT_MOD_TM |
Last Modified Time |
hh:mm am |
modified time |
Date/Time |
KT_ROWVER |
|
|
row version used for maintaining concurrency |
Date/Time |
KT_TACOST |
Cost |
nnnnnnnn.nn |
portion of cost associated with this task+asset combination |
Double |
KT_WT_ID |
Work Task |
-nnnnnnnn |
Long Integer |