Skip to main content
Skip table of contents

Q35InsertUpdateInstruction

Cantara Business Function which Creates, Updates or Deletes a work order instruction record in the F4802 based on the passed in parameters.

If the "mnLineNumberWorkOrder" field has a value and the "szDescriptionWorkOrder" field is null, then the relevant F4802 record if found will be deleted.

If the "mnLineNumberWorkOrder" field has a value and the "szDescriptionWorkOrder" has a value then the relevant F4802 record if found will be updated.

If the "mnLineNumberWorkOrder" field is null then its value will be default and a new F4802 record will be created. The "mnLineNumberWorkOrder" is defaulted by finding the highest value in the F4802 for the given work order, then incrementing that value by 1.

Data Structure

NameTypeInclusionDirection
mnDocumentOrderInvoiceEINTEGERREQUIREDIN
szOrderTypeUDCREQUIREDIN
szOrderSuffixSTRINGREQUIREDIN
cWODetailedRecordTypeUDCREQUIREDIN
szDescriptionWorkOrderSTRINGOPTIONALIN
mnLineNumberWorkOrderFLOATOPTIONALBOTH
szAssociatedItemNo1STRINGOPTIONALIN
szAssociatedItemNo2STRINGOPTIONALIN
szAssociatedItemNo3STRINGOPTIONALIN
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.