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

Name

Type

Inclusion

Direction

Parameter Notes 

mnDocumentOrderInvoiceE

INTEGER

REQUIRED

IN


szOrderType

UDC

REQUIRED

IN


szOrderSuffix

STRING

REQUIRED

IN


cWODetailedRecordType

UDC

REQUIRED

IN


szDescriptionWorkOrder

STRING

OPTIONAL

IN


mnLineNumberWorkOrder

FLOAT

OPTIONAL

BOTH


szAssociatedItemNo1

STRING

OPTIONAL

IN


szAssociatedItemNo2

STRING

OPTIONAL

IN


szAssociatedItemNo3

STRING

OPTIONAL

IN