Table Map – MOP/SOP Link

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.