Q35GetWorkOrderFetchInformation

Cantara Business function which is designed to be used by Cantara Client Applications.

Its purpose is to help speed up the process of retrieving a work order and its relevant data. For when downloading a work order from a Cantara Client Application it is best to know what additional data a work order has so the application can specifically fetch only that data over executing queries which could possible return no results.

The function will check for the following additional data on a work order, if valid data is found a '1' will be return to the relevant item:

  • Work Order First Text Attachment (F00165)

  • Media Objects (F00165)

  • Equipment Route (F1207)

  • Parts List (F3111)

  • Routing (F3112)

  • Failure Analysis (F48165)

  • Work Order Parts First Text Attachment (F00165)

  • Work Order Routing First Text Attachment (F00165)

Note

Work Order Parts and Routing attachments can be searched for optionally. Providing a value of '2' for either of these will bypass checking for those attachments.

This has been enabled in case searching through all Parts and/or Routing attachments is deemed to be too lengthy a process.


Data Structure

Name

Type

Inclusion

Direction

mnWorkOrderNumber

INTEGER

REQUIRED

IN

cHasFirstTextAttachment

CHARACTER

OPTIONAL

OUT

cHasMediaObjectAttachments

CHARACTER

OPTIONAL

OUT

cHasEquipmentRoute

CHARACTER

OPTIONAL

OUT

cHasPartsList

CHARACTER

OPTIONAL

OUT

cHasRouting

CHARACTER

OPTIONAL

OUT

cHasFailureAnlysis

CHARACTER

OPTIONAL

OUT

cHasTimeCards

CHARACTER

OPTIONAL

OUT

cHasPartsAttachments

CHARACTER

OPTIONAL

BOTH

cHasRoutingAttachments

CHARACTER

OPTIONAL

BOTH