Q35InsertUpdateInstruction

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

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