Work Order Resulting Tasks
Field Name |
Caption |
Mask |
Description |
Field Type |
WRT_CR_WO |
Auto Create by End DT |
|
Created Automatically based on End Date |
Boolean |
WRT_CRT_BY |
Created By |
25x |
Created By |
Text |
WRT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
WRT_DNUN |
Duration Interval |
10x |
Duration Interval Text |
Text |
WRT_DURN |
Duration |
nnn |
Duration Units |
Long Integer |
WRT_END_CL |
|
|
|
Boolean |
WRT_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
WRT_END_TM |
End Time |
hh:mm am |
End Time |
Date/Time |
WRT_FREQ |
Frequency |
nnn |
Frequency Units |
Long Integer |
WRT_FRUN |
Frequency Interval |
10x |
Frequency Interval Text |
Text |
WRT_ID |
Result Task Rec # |
nnnnn |
Unique ID |
Long Integer |
WRT_ITK_CD |
Initiating Task Code |
15x |
Initiating Task Code |
Text |
WRT_ITK_DT |
|
|
Initiating Date |
Date/Time |
WRT_ITK_ID |
Link to Initiating Task |
nnnnnnnn |
Long Integer |
|
WRT_ITK_TM |
|
|
Initiating Time |
Date/Time |
WRT_ITK_TY |
Initiating Task Type |
50x |
Initiating Task Text |
Text |
WRT_LINK_WO |
Link to Init. WO |
|
Link to Init. WO |
Boolean |
WRT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
WRT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
WRT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
WRT_OINVCD |
Occurence Interval |
nnn |
Occurence Interval |
7 |
WRT_OINVTY |
Occurence Interval Text |
25x |
Occurence Interval Text |
Text |
WRT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
WRT_RSCHNO |
|
18x |
Resulting Work Order Schedule Number |
Text |
WRT_RWO_ID |
Link to Resulting WO |
nnnnnnnn |
Long Integer |
|
WRT_RWONO |
WO Number |
18x |
WO Number |
Text |
WRT_STR_CL |
|
|
|
Boolean |
WRT_STR_DT |
Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
WRT_STR_TM |
Start Time |
hh:mm am |
Start Time |
Date/Time |
WRT_TK_ID |
Link to Resulting Task |
nnnnnnnn |
Long Integer |
|
WRT_TSK_CD |
Resulting Task Code |
15x |
Resulting Task Code |
Text |
WRT_TSK_TY |
Resulting Task Type |
50x |
Resulting Task Text |
Text |
WRT_WO_ID |
Link to WKORDER |
nnnnnnnn |
Long Integer |