Staging Tables

The following Staging Tables are used by the MO Receipt Integration (MORI).  Not all of the tables are required.

W7158MOHdr – this table is used to record the Item Number and Quantity to receive.  If other tables are included in the integration, such as the Picklist, the MOHdr table should be populated LAST.  MORI will read this table to find new receipts to process, so the Picklist and Routing tables should be populated first, then the MOHdr record created as the last step of your integration.  This ensures that MORI will not attempt to process the MO Receipt before you have finished populating the tables.

W7158MOHdrOpt – this table is used to provide optional settings if the defaults should not be used.  Optional settings can be provided for BOM Type & BOM Name, Routing Name, and Scheduling Preference, and Material Receipts Bin.  By default, MORI will use the MFG BOM, the Primary Routing, and the default Scheduling Preference.

W7158MOIVTrx – this table is used to provide a reference to Inventory Transfers that have been performed to move inventory for an MO from general inventory into WIP. Using this table is optional. See WIP Inventory for more details.

W7158MOPick – If provided only the MOHdr record, MORI will backflush components from the MFG BOM of the made item.  You can override this by providing actual component consumption by populating the MOPick table.

W7158MORouting – If provided only the MOHdr record, MORI will backflush labor based on the Primary Routing of the made item.  You can override this providing actual labor in the MORouting table.

W7158MOSer – this table is used to provide a list of serial numbers for an MO Receipt.