The MO Routing Staging Table must be populated if the W7158MOHdr table has column ImportRoute set to 1. The Routing table is used to REPLACE Setup Time, Labor Time, and Machine Time from the original Routing with the imported values. The Routing Sequences used in this table MUST exist on the Primary Routing. Routing Steps cannot be added.
The Working Routing for the MO will be created from the item’s Primary Routing. The Setup, Labor and Machine time values for all sequences will be set to zero. The MORouting table will then be used to set Setup, Labor and Machine to new values. If you routinely have rework, you should include a sequence on the Primary Routing for rework, with no labor/machine time. If rework is recorded during production, add the Rework routing sequence to MORouting and set the labor/machine time.
The MO Receipt Integration assumes that if MORouting is being used, you will provide ALL routing information (i.e. it zeros the Working Routing in GP, so any labor/machine time for any of the sequences must then come from MORouting).
|MANUFACTUREORDER_I||This column is a Key for the table.
30-char upper-case string.
The Manufacturing Order Number must be entered. A corresponding record in the W7158MOHdr must exist. The ImportRoute column in the W7158MOHdr table must be set to 1.
|SEQUENCE1||This column is the Key for the table.
This should match the SEQUENCE1 column in MOHdr.
|RTSEQNUM_I||This column is a Key for the table.
The Routing’s Sequence Number will be entered.
|SETUPTIME_I||The Routing Sequence’s Setup Time in hours.|
|LABORTIME_I||The Routing Sequence’s Labor Time in hours.|
|MACHINETIME_I||The Routing Sequence’s Machine Time in hours.|