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 |
---|---|---|---|
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 |