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 |