Table Map – MOP/SOP Link
This table is used only the the Create MOs utility. The physical name is W7158ImportMOPSOP. All fields are required.
| Col | Name | Notes |
| 1 | MONum | This is the Key on the table. It must match MONum in the Import Header table. Each MO can be linked to only one Sales Line. |
| 2 | SOPTYPE | Allowed values are:
2 = Order 3 = Invoice 5 = Backorder |
| 3 | SOPNUMBE | A valid Sales Document Number that exists in the Sales Header Work table (SOP10100). |
| 4 | LNITMSEQ | The Sales Line to which the MO will be linked. It must match a line in the Sales Line Work table (SOP10200). |
| 5 | QUANTITY | The MO Quantity. This is normally the same quantity that is recorded in the Import Header table, but it can be less. The MOP-SOP Link will be created using the SOP Line Quantity Backordered, or the MO Quantity, whichever is less. |